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 ...
Hiwillis71;
please attached the sample excel file to assist you on your query, you can remove that 24:00 by using IF Function..
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more