Avatar of bobrossi56

asked on 

Access 2003 field to calculate time durations

I am using Access 2003, and I am a NEWBIE @ Access, I have 2 fields on a form, START TIME and END TIME. I want to add a field for the duration of time entered. So if the user entered START TIME 10:00 AM and END TIME 11:00 AM the field will populate 1 hour.

The time duratoin will never exceed 24 hours, in fact the duration of time will never exceed 2-3 hours usually. This is for horse riding lessons, and the horses never usually get assigned to a student for more than 1-2 hours at a time.

thx experts...
Microsoft AccessSQL

Avatar of undefined
Last Comment
Patrick Matthews

8/22/2022 - Mon