Time calculations on a 24-hr clock

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

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