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