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

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:00In cell C1 enter the formula:

=IF(A1>B1,B1+1-A1,B1-A1)

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:

http://www.cpearson.com/excel/datea...

MIKE

Ask Your Question

Weekly Poll

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History