how do I calculate the difference between two given times in acce.

N

nigel007

I am using a 24 hour clock system and I need to calculate the difference
between two given times and display the result in a medium time format.

I am using office 2003
 
E

Eef Houniet

Hallo,

I need to calculate the following:

Given is an hour-tariff for salary.
Time-beginning and time-ending must be entered in fields.
To be calculated is the salary to be paid.

Entering times in a time-field en substracting the two values gives decimal
values that I don't know how to use.

What types of fields should I use, or what expression in a query?
 
D

Douglas J. Steele

The DateDiff function will let you calculate the difference in whatever
units you want (seconds, minutes or hours)
 
Top