the company I work for has a rule where we can only work 12 hrs in any 24hr time period
how can i work this out in an excel spreadsheet if eg: Day 1 start shift 11:30am finish 21:00pm, day 2 start 7:00am finish 16:30pm I’d like to work out how many hr i work from any point in day 1 to 24hr later in day 2. thanks
