LinkBack URL
About LinkBacks
Hi There,
Rather than manually typing the time in 5 min increments across a range of cells, i want to have a start time, then the next cell add 5 mins.
EG: 09:00 next cell 09:05 and so on.
Thanks for the help
Hi There,
Rather than manually typing the time in 5 min increments across a range of cells, i want to have a start time, then the next cell add 5 mins.
EG: 09:00 next cell 09:05 and so on.
Thanks for the help
If you have 09:00 in Cell "A1" Then A2 = A1+5/1440
With 09:00 in A1, 09:05 in the next, select both cells and drag across or down
Ben Van Johnson
In A1 manually type 09:00
in A2
=A1+5/24/60
Copy down
Life's a spreadsheet, Excel!
Say thanks, Click *
Thank you for the rapid replies.
Have done it before but could not remember how.
Enjoy your day.
Another way around without formula.....
Like fill A1=9:00 and B1=9:05 and now select A1:B1 and drag the fill handle across (to C1,D1,E1....so on) as far as you need.
Does this help?
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Thanks sktneer,
yes it does help.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks