MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Time and space


Posted by Jacob on July 25, 2001 4:52 AM

Hey,

Problem:Time
Goal Fact = Diff.
00:25 23:25 XXXXXX
23:25 01:25 XXXXXX

Excel 95 and 97

Please help

/ Jacob


Posted by Ian on July 25, 2001 7:22 AM

in c1 put =b1-a1

Any help

Ian

Posted by Aladin Akyurek on July 25, 2001 8:19 AM

Ian,

Make that =b1+(b1 < a1)-a1

to avoid getting negative results.

Aladin