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?
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?
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>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks