MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Time Calculation


Posted by Ted Shaughnessy on February 14, 2002 4:41 PM

Need to be able to calculate minutes early from a scheduled time. I can get the minutes past a scheduled time but not the early part.
I.E. Scheduled time is 9:00 and the time stamp shows 8:55. Need to see (0:05) or -O:05....etc.

Basically trying to track time past and schedule or time made up on a schedule.


Posted by Dreamboat on February 14, 2002 7:14 PM

Excel won't give you negative time values. But I don't see anything wrong with =A1-B1 where A1 is 9:00am and B1 is 8:55am. Even if you tried to use something like ="("&a1-b1&")", it would turn the format into text and wouldn't display the 0:05 anymore.

Lots of info on dates and times (hope Mr. Excel doesn't mind!!) at the bottom of this page:
http://www.cpearson.com/excel/DateTimeWS.htm


Posted by Barrie Davidson on February 14, 2002 7:51 PM

Actually, Excel will give you negative time values.


If you change your date options to "1904 Date System", Excel will calculate the formula above as -0:05.

Many thanks to Aladin Akyurek for teaching me this little tidbit!

BarrieBarrie Davidson