Elapsed time over 24 hours

#1 (**permalink**) 28-Jul-2006, 08:39 AM

We are trying to make a Database to track trades in our FD Department.
Fields:
Name
Worked for Him
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13757-elapsed-time-over-24-hours.html
Worked for Me
StartTime Ex. (07/13/06 06:45 AM)
EndTime Ex. (07/14/06 07:00 AM)
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13757
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.

*

#2 (**permalink**) 28-Jul-2006, 08:39 AM

The Date/Time data type is intended for timestamps (i.e.: specific date/time
points in time) as opposed to durations.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13757

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

"Fast Learner" wrote in message
news:3218737E-D700-48DB-BC68-5FBBD726D449@microsoft.com...
> We are trying to make a Database to track trades in our FD Department.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13757
> 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.
>