LinkBack URL
About LinkBacks
suedavies 
I need to find a formula to copy down time so that it increments by 1 min every 5th row
eg Rows 1- 4 are 8:01 and rows 5 -8 are 8:02 and so on for 1000 lines
Thanks
Fill an incremental time entry in blocks of 4 rows
I need to find a formula to copy down time so that it increments by 1 min every 5th row
eg Rows 1- 4 are 8:01 and rows 5 -8 are 8:02 and so on for 1000 lines
Thanks
Hello
With your start time in A1, try in cell A2 copied down:
Hope this helps.
=IF(MOD(ROW(),5),A1,A1+TIME(0,1,0))
DBY
that would need to be in a2
=IF(MOD(ROW(A1),4),A1,A1+TIME(0,1,0))
to get
08:01
08:01
08:01
08:01
08:02
08:02
08:02
08:02
08:03
08:03
08:03
08:03
if you just use row() you get
08:01
08:01
08:01
08:02
08:02
08:02
08:02
08:03
08:03
08:03
08:03
08:04
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Martin, that's what I've done. It seems to work for me. I get an increment of 1 minute every 5 rows, unless I've misunderstood.With your start time in A1, try in cell A2 copied down:
Thank you Martin and DBY
Thats working great now
Thank you both for your assistance
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks