Time Calculaion Needed 1

[Fireman1143]

I am trying to do a time calculation in Access where I have:
[ScheduledTime] in hh:mm AM/PM format
[Duration] in hours in numeric fixed 2 decimal format

My third field is to be calculated where the [ScheduledTime] and [Duration] are added to get a [EndTime] in hh:mm AM/PM format.

Although numerous threads address elasped time and I have tried to use them as a model, the Access Date/Time is driving me nuts. Any help with how to change [Duration] to minutes, seconds or whatever is needed would be appreciated.

Thanks,
Fireman1143

 

[dhookom]

Try
EndTime: DateAdd("n",Duration * 60, [ScheduleTime])

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Fireman1143]

Thanks dhookom You made this one look simple, after it drove me crazy for two days!

Fireman1143