Solved Time calculations for standing times on machinery

March 11, 2014 at 02:27:01
Specs: Windows 7
I need to calculate standing times for machinery and keep getting error results when start time is greater than end time
Date From To Standing time
12/02/14 07:15:00 09:15:00 02:00:00
23:15:00 03:25:33 #####

message edited by Erra

See More: Time calculations for standing times on machinery

Report •

March 11, 2014 at 06:26:17
✔ Best Answer
Not sure how you have your sheet set up, but try this:

With your Start Time in A1 and your End Time in B1

      A            B
1) 09:15:00     02:00:00

In cell C1 enter the formula:


Since B1 is the next day, you need to add 1 to get the correct time.

Don't forget to format cell C1 as Time

For a very good in depth explanation of how to do TIME Math in Excel see here:


Report •
Related Solutions

Ask Question