adding one hour onto time

[SAMZIE]

Hi,
ive searched the forums for this but cant find anywhere.

how can i add one hour onto a time stamp please.

many thanks

 

[Dennisk]

look up the DATEADD Function

 

[SAMZIE]

thanks,
anyone want to expand on this as i havent a clue!
each time i use the time stamp tool i want to have another column display the time an hour in advance i.e column One,TIME Now 11:23 & column Two time delivery to be completed 12:23

Any help is appreciated as this is used in a hospital and help get patients notes to the ward on time!

 

[ColinEssex]

= DateAdd("h", 1, [YourField])

Its in Access help

Col

 

[gemma-the-husky]

please note that the time portion of a date is strictly 24hours - the time is actually stored as a fraction of a day

so 8hrs+1 = 9hrs

but 23.30 hrs +1 = 0.30 hrs and can NEVER go above 24hrs