Time and Date increment
 

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

"Myrna Larson" wrote:

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.


On Fri, 16 Jul 2004 05:37:02 -0700, "La La Lara"
wrote:

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?