Elapsed time over 24 hours

[Guest]

We are trying to make a Database to track trades in our FD Department.
Fields:
Name
Worked for Him
Worked for Me
StartTime Ex. (07/13/06 06:45 AM)
EndTime Ex. (07/14/06 07:00 AM)
Total Hours Worked
We take the EndTime-StartTime to get Total Hours Worked but we can't seem to
get it to give the correct amount of time.What should the fields be formatted
to? Also we need a Report to show individual totals for time owed or time due
by each member.

 

[Douglas J. Steele]

The Date/Time data type is intended for timestamps (i.e.: specific date/time
points in time) as opposed to durations.

Reallistically, you should figure out what granularity you need for your
time duration (minutes? seconds?) and use DateDiff to figure out the
duration in those units. You can write a function to convert from, say,
total minutes to total hours and minutes.