Calculating amount of time spent

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have two fields: Date/Time Started and Date/Time Finished. If I create a
third field called Amount of Time Spent, Is there a function I can include in
it that will calculate the amount of time elapsed between Date/Time Started
and Date/Time Finished?

Thanks,
 
Rosemary said:
Hi,

I have two fields: Date/Time Started and Date/Time Finished. If I
create a third field called Amount of Time Spent, Is there a function
I can include in it that will calculate the amount of time elapsed
between Date/Time Started and Date/Time Finished?
Click to expand...

In what units? The DateDiff() function can give it to you in seconds,
which you can convert to larger units by dividing appropriately. It
won't give you accuracy below a second or so, though.

And then there's the "better DateDiff function" posted here:

http://www.pacificdb.com.au/MVP/Code/Diff2Dates.htm
 
If calculating hour differences:

DateDiff("h", [DateTimeStarted],[DateTimeFinished])

HTH
Sam
 
Back
Top