calculating time fields

[bashyam]

Hello!!! guys...this is my first posting here and i hope i get a good response

Well here is my problem. I working on an access 2002 database and i have problems adding a time field with a number field which has to be done like (time_on + duration) which i have to put in the time_off field, which is again a time field.

Both the time fields (time_on,time_off) are using SHORT TIME format.

The result to be put in the time_off is to be a time
eg: 12:50 + 15 = 13:05

Can anyone help me calculate this in my query!!!

THkns in advance....

 

[asnyder]

If your always going to add minutes you would use this format:
=DateAdd("n",15,StartTime).

You can use a variable where the 15 is.