Timesheet: Calculate Time within a period when crossing midnight

**G0liath02** · 05-15-2009, 02:58 AM

I would love it if it were that simple. And will have a big laugh at myself if it turns out to be something like that!!

Unfortunately I have 3 different time periods i need to calculate.

1 Ord Mon-Sat 7:30 - 20:00
2 Penalty Mon-Sat 20:00 - 0:00
3 Night Mon-Sat 24:00 - 7:30

Any ideas?

**DonkeyOte** · 05-15-2009, 03:08 AM

OK, I would suggest you post another sample file with a few variations of shifts and clearly identify the expected results.
In truth it's always best to start with the real problem rather than a simplified version thereof - what works for one scenario may well fail to work for another...