Hi,

I have a timesheet which for certain days of the year calculates double-time. What i would like to do is have a formula that gives double time for a 24 hour period. I have a formula setup with a start time and end time for my double time, but it wont stop at midnight.

let me know if you need more details.

The formula i use is 

=(R10>S10)*MEDIAN(0,S10-R41,R42-R41)+MAX(0,MIN(R42,S10+(R10>S10))-MAX(R41,R10))