How to calculate the total hours worked from the excel with the help of in time and out time
![]() |
How to calculate the total hours worked from the excel with the help of in time and out time
A2 - TIME IN (in Excel time format: 8:00 AM)
B2 - TIME OUT (in Excel time format: 4:30 PM)
C2: =(B2 - A2) * 24 (formatted as General or Number)
If you have to deal with shifts that go past midnight, you have to check for that.
C2: =((B2-A2) + (A2>B2)) * 24
Sample attached.
All times are GMT -7. The time now is 07:48 PM. |