Adding minutes to a time

[wjoc1]

Hi,

If I have a time like 22:00 and I want to add lets say 300 minutes to it; so it now shows 03:00 how do I do this? I can do it in Excel alright with the TIME function but cannot find a similar feature in Access

Liam

 

[Len Boorman]

Think

If you have a field with data type specified as time then a decimal 0.5 =12:00, So to add minutes you end up with

Update Time to Time +(Minutes/60) Thats just to illustrate the process.

Len