Timesheet help wanted-IF blank?

[scottylad2]

Hi there

I have a timesheet which calculates overtime and the sheet works ok. I've had help on this board constructing it and i'm well pleased so far. what i need for it now, is if there is an input cell with no data in it, i want the results cell to stay blank but at the moment i'm getting those horrid hash symbols.

The formula just now is end time minus start time, and from that a 45 minute break is deducted. The break is always the same so i have that in a cell on it's own and the formula does an end minus start, then - the break. What i'd like is when there's no data in the cells, leave the result cell blank.

many thanks

Excel Workbook
	E	F	G	H	I	J	K	L
14	06:45	18:00						10:30
15	16:00	02:00						9:15
16	23:00	07:00						7:15
17								########
18								########
19								########
20								########
21								########
22								########
23								########
24								########
25								########
26								########
27			0.00	0.00	0.00	0.00	0.00	19:30
28
29					SIGNED :____________________________________
30					0:45
UPDATED VERSION

 

[VoG]

Try

=IF(OR(E14="",F14=""),"",MOD(F14-E14,1)-I$30)

 

[scottylad2]

VOG that was fantastically quick and works a treat. Thanks, i LOVE this board, the worlds smartest Excelers and a reply within a few minutes.

Thanks again