Adding hours to a time field?

  • Thread starter Thread starter Jerome
  • Start date Start date
J

Jerome

Hello,

I've got the following:

A list of workshops with their starting times (9:00, 10:00, etc) and
their duration (60 min, 90 min, whatever).

How do I now calculate the respective ending times of those workshops?

The Starting Times field is a Date/Time field.
The duration field a numeric field.

It's something with DateAdd, but I don't know the exact function.

Could somebody please help me?

Thank you very much,

Jerome
 
Type this field into a query (Field row) to show the ending time:
EndTime: DateAdd("n", [Duration], [Starting Times])

Be sure to use N to add minutes: M adds months.
 
Back
Top