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

[Rajesh Kr Joshi]

Hi Experts please help in following:

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

Thank YouTime split file.xlsx
Rajesh

[Admin]

Hi,

In F3,

=C4

In G3 and copied across,

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

HTH