Time calculations on a 24-hr clock [Solved/Closed]

Report
Posts
3
Registration date
Friday January 25, 2013
Status
Member
Last seen
February 1, 2013
-
Posts
2368
Registration date
Sunday September 23, 2012
Status
Moderator
Last seen
December 13, 2018
-
Hello,

I need a formula that I can apply to my spreadsheet that will calculate how much time it takes someone to complete a task. Everything is based on start time (HH:MM:SS) and end time (HH:MM:SS). I currently have =(L2-K2) which is great but doesn't take into accont if the start time and end time are on different days. How do I fix this? Many thanks in advance for your help.

1 reply

Posts
2368
Registration date
Sunday September 23, 2012
Status
Moderator
Last seen
December 13, 2018
36
Hi Harters,

You can use the DATEDIF Worksheet Function to accomplish this task. For more details you can visit the following link:

http://www.cpearson.com/excel/datedif.aspx

Please revert for clarification.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!