How can I subtract military time

[paulalvin]

For example I logged in as 18:00pm and logged out as 02:00am what will be the best way to get the total hours?

[dilipandey]

HI paulalvin,

I am not sure how you got 18:00pm ?
Either it should be 18:00 or 06:00 PM...check and confirm.
Also do you have dates as well in your data along with time ?

Regards,
DILIPandey

<click on below 'star' if this helps>

[CheshireCat]

If you are sure none of your total hours will exceed 24 hours, and you have the times properly entered into Excel, then you could use the following:

A2 = log in time
B2 = log out time

Please Login or Register  to view this content.