LinkBack URL
About LinkBacks
Hi
Having trouble or have just forgot looking to enter the time in cell B2 e.g. 12.00 then in the next cell 12.30, 1.00, 1.30 but its not doing it the way I thought
Toddp
entering the time in each cell
Hi
Having trouble or have just forgot looking to enter the time in cell B2 e.g. 12.00 then in the next cell 12.30, 1.00, 1.30 but its not doing it the way I thought
Toddp
Last edited by toddp2; 10-23-2016 at 04:43 AM. Reason: adding file
write in B2 12:00
Then in B3 use formula =B1+0.5/24
0.5 / 24 (half hour step divided by 24 hours... So if you want to change step then change this factor).
...or put 12:00 in B2 and 12:30 in B3. Select both cells and drag down.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Depending on what the OP is going to use this for, both suggestions have/create rounding errors.
B2:Bn = sequence generated by one of the suggestions
Try this...
D2 = 13:00 (manually entered)
E2: =MATCH(D2,B:B,0)
Result: #N/A
And you'll get the same result for many attempted matches.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Try this...
Enter 12:00 AM in B2
Enter this formula in C2:
=ROUND((B2+TIME(0,30,0))*1440,0)/1440
Format as h:mm am/pm then copy across as needed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks