Spreading a time range (shift time, etc) in columns.

Hi Experts please help in following:

I want to distribute shift timing in column with 1 hour difference. Attached is the sample file .

Thank YouAttachment 90
Rajesh

Hi,

In F3,

=C4

In G3 and copied across,

=TIME(HOUR(F3)+1,0,0)

HTH