Time format, timesummary less than - 24 hours

S

Snoopy

Hey
In my timesummary worksheet there will be both positive and negative
results.
When the result exceeds 24 hours, the result appear as a lower time
value (tt:mm minus 24 hours) - allways less than 24 hours.

My cellformat is: tt:mm;@
And Tools/Options/Calculation is set to 1904-date format

How kan I format the cells to show timeresults (both positive an
negative) in actual totals?

I'll appreciate your sugestions
Regards Snoopy
 
D

Dave Peterson

Try formatting the cell like:

[hh]:mm:ss

The square brackets will show the hours.
 
Top