Access 2003 field to calculate time durations
Posted on 2011-10-02
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.