Question Locked

time worked calculation over 2 days

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

1 reply

This discussion is closed to new replies.