Time Sheet

[George A. Yorks]

Need information to create a time sheet with 9 minute
increments. ie: cell A3 time 1:03 PM, want A4 to read
1:12PM, A5 to read 1:21 PM, etc to A38 to read 6:36 PM

Any help appreciated

 

[JE McGimpsey]

one way:

A4: =A3 + TIME(0,9,0)

Copy down as far as necessary.

 

[Harald Staff]

Hi

Formula in A4:
=A3+9/1440
Fill downwards as long as you need.

There are 1440 minutes in a day, so that's where the number comes from.

HTH. Best wishes Harald