Hi Peter

I had not meant that formula was complete, merely that you should
replace that part of your formula.
Glad you got it sorted out.

--
Regards

Roger Govier


"Peter Mount" wrote in message
ups.com...
Hi Roger

I modified your suggestion to be:

=IF(SUM(K20:K21)0;MOD(K21-K20;1)-TIME(0;30;0);"")

That way if no times are entered for that day the total cell is blank
instead of ########, which I found to have an affect on the total for
the week at the end of the row of days.

Thanks very much for your help

Have fun

Peter Mount

Roger Govier wrote:
Hi Peter

Try
=MOD(K21-K20,1)-TIME(0,30,0)

--
Regards

Roger Govier