Solved I would like to calculate the difference of times in H:M:S f

April 24, 2012 at 10:59:53
Specs: Windows 64
I would like to calculate the difference betwween time in two different cells.
actual time versus projects time in a format permiting both the positive and negative difference.
Use is for projecting a sport time to be projected and the actual performance.

TIME STAMP ACTUAL RUN TIME ACTUAL LENGTH PROJECTED DIFFERENCE
x 11:57:16 AM 0:00:17 12:00:00 PM


See More: I would like to calculate the difference of times in H:M:S f

Report •


#1
April 24, 2012 at 11:22:59
✔ Best Answer
You can simply subtract the values in 2 cells containing times to get the difference, but only for positive differences.

Excel does not allow negative times in a cell, although there is a workaround.

See here for lots of info on Time & Date functions, including how to deal with "negative times":

http://www.ozgrid.com/Excel/date-ti...

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question