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

Question

Previous Topic Next Topic

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

Report

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

Time calculations on a 24-hr clock
Garmin vivoactive 4 24 hour clock - How-To - Mobile
Time calculation ✓ - Forum - Excel
Time calculation (TimeXnumber) ✓ - Forum - Excel
Time of day clock stopped dell - How-To - Laptop computer
Time of day clock stopped ✓ - Forum - Hardware

1 reply

Ask a question

Zohaib R · Answer 1 · 2013-02-02T08:10:52-0500

Answer 1 / 1

Zohaib R

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

36
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.

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

1 reply

Your reply

Subscribe To Our Newsletter!