Previous Topic Next Topic

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

Answer 1 / 1
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 67
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