Help with adding times to give the result as the day

[Jimbo]

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

 

[T. Valko]

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

 

[Jimbo]

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

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

 

[T. Valko]

Hmmm...

So what's in B1? Is that the starting time?

If A1 is a date formatted to display as Monday, try this in A2:

=A$1+B$1+SUM(C$1:C1)

Format as dddd

Copy down as needed. Based on the sample data these will be the results:

A2 = Monday
A3 = Monday
A4 = Monday
A5 = Tuesday