Time calculations on a 24-hr clock

Solved/Closed
Harters
Posts
3
Registration date
Friday January 25, 2013
Status
Member
Last seen
February 1, 2013
- Feb 1, 2013 at 11:11 PM
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
- Feb 2, 2013 at 08:10 AM
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

Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
68
Feb 2, 2013 at 08:10 AM
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.
0