Time Sheet

  • Thread starter George A. Yorks
  • Start date
G

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
 
H

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
 
Top