Add half hour

[Connie Martin]

If I formulate a column to time, and if the time in the first cell is 6:00 AM
and I drag it down, it advances by one hour. How do I get it to advance by a
half hour?
Connie

 

[Steve]

If I formulate a column to time, and if the time in the first cell is 6:00AM
and I drag it down, it advances by one hour.  How do I get it to advanceby a
half hour?
Connie

Place 6:30 in the cell below it and than select both cells and drag
down. This will set the time to 30 minute intervolts

 

[Marcelo]

assuming you have 06:00 AM on g7.
on g8 use =g7+(0.5/24) hit enter and drag it down

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Connie Martin" escreveu:

 

[Connie Martin]

Thank you very much! That works fabulously!

From Canada with thanks...Connie

 

[uturnabout]

A simple way is to type 6:00 AM in the first cell and 6:30 AM in the second
cell.
Then select both cells and drag down.

For a formula, assuming you type your time in A1, type the following in A2
and drag that cell down

=A1+30/1440

 

[Connie Martin]

Wow! That's so simple! Thank you very much! Connie

 

[Connie Martin]

Thank you! This is amazing that there are three different ways now to do it,
but I like the simplest one---your first one. Thanks again! Connie

 

[Marcelo]

Thanks for the feedaback Connie
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Connie Martin" escreveu: