Calculating time in Access 2000 - TechRepublic
General discussion
July 11, 2002 at 02:06 AM
ray gross

Calculating time in Access 2000

by ray gross . Updated 23 years, 9 months ago

I have 2 time fields: StartTime and EndTime.

I want a third field (TotalTime) to Automatically calculate the value of EndTime minus StartTime and display the result in an HH:MM (short time) format.

How do I do this?

This discussion is locked

All Comments