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
> 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
> 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
> get it to give the correct amount of time.What should the fields be
> to? Also we need a Report to show individual totals for time owed or time
> by each member.