Formulas

  • Thread starter Thread starter Simon
  • Start date Start date
S

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)),"")
 
Back
Top