How do I calculate elapsed time between start time and end time. I want my Length field to be populated automatically by calculating the elapsed time between start and end.
Novice
Windows 8 
Access 2010 64bit
How do I calculate elapsed time between start time and end time. I want my Length field to be populated automatically by calculating the elapsed time between start and end.
Sometimes Helpful
Windows 7 64bit Access 2010 32bit
Have you looked into the DateDiff() function?
VIP
Windows 7 64bit Access 2007
What kind of times are we speaking of? In what format do you want your results, i.e. minutes... hours and minutes... days, hours and minutes?
Generally speaking, you use DateDiff(), as has been suggested, using the smallest unit of time you want to report. If you want hours and minutes you use minutes as the Interval in DateDiff() and then parse it out into hours and minutes.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007
calculating total time but excluding overlapping time
Calculating a time string not formatted as Date/Time
Posting Permissions
Reply With Quote