Hi
I have a timesheet, but dont know how to calculate hours between 17:00 and 07:00
C5 is when I start working
D5 is when i'm done.
G5 is the evening hours (between 17-07)
My code in G5: =((D5>17/24)*(D5-17/24)+(D5<C5)*(D5+1-17/24)-(D5<C5)*(D5>1/24)*(D5-1/24)-(C5>17/24)*(D5-17/24))*24
But when I work night from 21-07 it will return 18, not 10...
Bookmarks