how to add total hours worked between two dates?

[whix]

We are creating a database where we want to enter an employee name, start date and an end date. This database will be joined to another database (2nd database) that has a date field and an hours field.
We want the new database to tell us how many hours in total were worked between those two dates. (from the 2nd database, which is a data entry database where we enter an employee name, hours worked and the date)

 

[paulbent]

You can do everything with calculated fields.

Subtracting the start date from the end date returns the elapsed time in days.

Subtracting the start time from the end time returns the elapsed time in hundredths of a second; divide by 360000 to convert to hours.

There's an example (Timelaps.zip) of how to do the calculations in the Free Downloads section at

http://www.xpertss.com

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk