Calculate Elapsed Time

[Michael]

Hi Folks - I will need to calculate elapsed time. Is it best to store the
date and time in separate fields, or to have only one field with the date
and time? Thanks.

Michael

 

[Allen Browne]

In the absence of any further details, my recommendation would be to use
combined date/time fields.

For info on calculating and displaying the difference, see:
Calculating elapsed time
at:
http://allenbrowne.com/casu-13.html

 

[Dale Fye]

If you are talking about calculating and storing elapsed time, I would
recommend against it. It is generally frowned upon to store computed values
in a table, when they can easily be computed via a query. Just store the
start time and the End Time, and compute the Elapsed time whenever you need
it.

I generally store the date and time components in a single field, rather
than trying to separate them.
--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.