The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.
Spreadsheet Help
Roland of Gilead
Registered User regular
Registered User regular
Ok. I'm Building a timecard and I'm having a brain fart.
I've got two fields One for Start Time and one for End time. Both are Formatted HH:MM AM/PM I want to write a function to add up the hours worked and I can't seem to make it work. It needs to work across midnight as we often work 12+ hour shifts overnight. I know theres an easy way to do this as I've done it before but I can't seem to get it to go.
I've got two fields One for Start Time and one for End time. Both are Formatted HH:MM AM/PM I want to write a function to add up the hours worked and I can't seem to make it work. It needs to work across midnight as we often work 12+ hour shifts overnight. I know theres an easy way to do this as I've done it before but I can't seem to get it to go.
Roland of Gilead on
0
Posts
edit: you'll also want to put the 'day' in the field, not just hour.
IF(A<B,B-A,Midnight-A+B)
Satans..... hints.....
Could you elaborate on this a bit?
=IF(HOUR(C3)-HOUR(B3)<0, 24 + HOUR(C3)-HOUR(B3), HOUR(C3)-HOUR(B3))
Change the cell references to match, obviously.