"T. Valko" wrote:

Can you show us a small example and tell us what result you expect?

--
Biff
Microsoft Excel MVP
Thanks for the reply

Below is a copy rom my worksheet
A B C
MON 02:00:00 07:00:00
? 09:00:00 04:00:00
? 13:00:00 10:00:00
? 23:00:00 24:00:00
? 23:00:00 05:00:00

In cell a1 the start day is entered from a list, c1 is the job length, b2 is the sum of b1+c1 then I would like the day to be displayed in a2.......ax. Hope that makes sense
"Jimbo" wrote in message
...
Help please! In cell A1 I have displayed MONDAY ,in cell B1 I have time in
HH:mm:ss format, as I enter times in column B I would like to sum the
total
and enter the resulting day in column A any help appreciated