Forum Discussion
Time formula in Excel
I'm using a time formula to calculate 12 am to 12 am between two days as 24:00 in an employee time log sheet. =IF(C15>B15,C15-B15,C15+1-B15) I also have the formula total each daily column into a ...
As variant
=MOD(C10-B10,1)displays overnight and one day hours as well as zero if both times are missed