Add half hour
 

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

Add half hour
 

On May 21, 11:40*am, Connie Martin
wrote:
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

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

Add half hour
 

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:

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

Add half hour
 

Thank you very much! That works fabulously!

From Canada with thanks...Connie

"Marcelo" wrote:

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:

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

Add half hour
 

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" wrote:

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

Add half hour
 

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

"Steve" wrote:

On May 21, 11:40 am, Connie Martin
wrote:
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

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

Add half hour
 

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

"uturnabout" wrote:

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" wrote:

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

Add half hour
 

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



"Connie Martin" escreveu:

Thank you very much! That works fabulously!

From Canada with thanks...Connie

"Marcelo" wrote:

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:

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