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.
Related:

1 response

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

Similar discussions

Facebook says I have been trying too often
Sameer -
owilson -

2 responses
you have requested too many SMS codes. you must wait 24 hours to receive another
Meyusake -
HelpiOS -

3 responses
The system time is invalid
LeonardPromise -
Jules_St-Germain -

5 responses
We can't review this decision
03425911668 -
HelpiOS -

5 responses