time worked calculation over 2 days

By Imanoone2u ·
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

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums