Calculating amount of time spent

[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,

 

[Allen Browne]

See:
Calculating elapsed time
at:
http://members.iinet.net.au/~allenbrowne/casu-13.html

 

[Dirk Goldgar]

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?

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

 

[Guest]

If calculating hour differences:

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

HTH
Sam