Time and Date increment

[Guest]

Hi

I have a date and time field (which I have formatted as dd/mm/yy hh.mm)

16/07/04 09:30

I would like to add (incrementally) an hour on to the time each day, so the first few days will be:

17/07/04 10:30
18/07/04 12:30
19/07/04 15:30

I have tried right-clicking and using the "series" function, but when I go into the "series" option I am not sure what to do. I have chosen the options step value = 1 and "growth" but it only updates the Day (dd) by one day. I can't get it to update the Hour (hh) by one hour each day.

Any ideas anyone?

 

[Andy B]

Hi

You need to add 1 to increment the day and 1/24 to increment one hour.
=A2+1+(1/24)
in simple terms should do the trick. You can then fill this down.

--
Andy.

Hi

I have a date and time field (which I have formatted as dd/mm/yy hh.mm)

16/07/04 09:30

I would like to add (incrementally) an hour on to the time each day, so the first few days will be:

17/07/04 10:30
18/07/04 12:30
19/07/04 15:30

I have tried right-clicking and using the "series" function, but when I go

into the "series" option I am not sure what to do. I have chosen the
options step value = 1 and "growth" but it only updates the Day (dd) by one
day. I can't get it to update the Hour (hh) by one hour each day.

 

[Jason Morin]

Off the top of my head, here's 3 ways to add 1 hour:

=A1+1/24
=A1+"1:00"
=A1+TIME(1,,)

HTH
Jason
Atlanta, GA

-----Original Message-----
Hi

I have a date and time field (which I have formatted as dd/mm/yy hh.mm)

16/07/04 09:30

I would like to add (incrementally) an hour on to the

time each day, so the first few days will be:

17/07/04 10:30
18/07/04 12:30
19/07/04 15:30

I have tried right-clicking and using the "series"

function, but when I go into the "series" option I am not
sure what to do. I have chosen the options step value =
1 and "growth" but it only updates the Day (dd) by one
day. I can't get it to update the Hour (hh) by one hour
each day.

 

[Myrna Larson]

I'm confused by your examples. On the 17th you added just 1 hour, but on the
18 you added 2 hours and on the 19th 3 hours. What increment do you want?

Do you want to add 25 hours each time? If so, you can just write the formula
in A2 =A1+25/24 and copy down.

Hi

I have a date and time field (which I have formatted as dd/mm/yy hh.mm)

16/07/04 09:30

I would like to add (incrementally) an hour on to the time each day, so the first few days will be:

17/07/04 10:30
18/07/04 12:30
19/07/04 15:30

I have tried right-clicking and using the "series" function, but when I go

into the "series" option I am not sure what to do. I have chosen the options
step value = 1 and "growth" but it only updates the Day (dd) by one day. I
can't get it to update the Hour (hh) by one hour each day.

 

[Guest]

Myrna, Andy and Jason have given me the answers I need - many thnaks!