Hi Guys
I need a formula to calculate hours between two times & date. Please refer to the attached sample file that I have created to have better view on my question. Thanks.
From my research on the net, I found few formula that might helped. However, those are formula for the data not exceeding 24 hours as per below.
Formula A - Remarks - It is working. However, those exceeding 24 hours, the data will be display incorrectly. e.g. C10.
Hours =TEXT(B2-A2,"h:mm")
Formula B - Remarks - Working but it can't display minutes & those exceeding 24 hours will be incorrect. e.g. D2.
Hours =HOUR(B2-A2)
Formula C - Remarks - I tried to separate date & time to use this formula, however, the outcome is incorrect.
Hours = ((End_Date+End_Time)-(Start_Date+Start_Time))*24
Bookmarks