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

[Guest]

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

 

[Douglas J. Steele]

Use DateDiff to calculate the difference in seconds (DateDiff("s",
DateTime1, DateTIme2)), then convert the results yourself.

Alternatively, take a look at
http://members.rogers.com/douglas.j.steele/Diff2Dates.html

 

[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?

 

[Douglas J. Steele]

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

 

[Eef Houniet]

Douglas,

Thank you for your prompt reply.

Eef Houniet