negative time expressed in -hh:mm:ss
Posted by Kelly on September 28, 2001 6:18 AM
I am doing schedule adherence. I need to be able to take the hh:mm:ss value in cell B1 (scheduled departure time) and subtract the hh:mm:ss value in cell A1 (actual departure time) and place the answer in cell C1 as value mm:ss, where cell C1 may have a negative value -mm:ss. Two examples follow:
A B C
1 22:35:14 22:40:00 04:46
2 22:42:37 22:40:00 -02:37
Seems simple, please help....