Formulas

[Simon]

I am using the current formula on a timesheet to work out
how many hours:minutes I have worked over 7 hours.
Unfortunatly if I do less than 7 hours then the cell
displays ########. Is there a way I can show all positive
and negative values???

=IF(AND(C10<>"",F10<>""),(G10-TIME(7,0,0)),"")

 

[Frank Kabel]

Hi
if you need negative times one way would be to change the settings in
'Tools - Options - Calculation' to '1904 dates'.
Note: This will change your dates in your workbook and may cause
problems. Also see
http://j-walk.com/ss/excel/usertips/tip051.htm
for more information