A Negative problem

Hi,

I have fashioned a time sheet to measure my working day/week


The problem I'm having is when i seperate my overtime i.e I work more than 7hrs:30m is fine I can minus one from the other i.e I work 9hrs:30 minus 7hrs:30 equal 2 hrs overtime or 2:00 in the cell.

The problem is when I work less i get "#######" in the cell, how do i get round this? I just want it to show "00:00"

Any help would be appreciated

Hi If Your Total time worked is in "A1" and your stardard day is in "B1" then this formula should give you your required result.

=+IF(A1<B1,"00.00",A1-B1)

Regards mick