Time formula
 

Hi folks,

I have a time sheet with the following on it.

Start Finish Total Overtime
Time Back
0700 1600 8:00hrs 0:30mins
0:00

what I need is a formula so when a time is entered as 0:00 through start and
finish this registers as 7:30 in the time back column, also I need it to
return 0:00 in overtime column but it is returing ############# as it is
negative.

Dies anyone have any ideas for me, would be much appreciated.

Regards,

Mark