|
Access wiki - Access Help and How-to - Microsoft Office > Viewing Summing elapsed time that could go over 24 hours
|
|
Menu
Content
Resources
To Do
Toolbox
|
A fairly frequently asked question is how to display a total of elapsed time in hours and minutes when this goes over 24 hours ( as the short time format won't work). The following expression solves this problem: It assumes that elapsed time is calcaulated as the difference between start time end end time fields. CODE Int(Sum(DateDiff("n",[startTime],[endtime])/60)) & ":" & Format(Sum(DateDiff("n",[startTime],[endtime])) Mod 60,"00")
The content of this Access Wiki article was migrated from the UtterAccess FAQA forum and cannot be edited at this time. If you are the original author and would like the article unlocked as a standard wiki article, which enables editing by others, or you are a reader and have identified errors that warrant the removal of this article, please notify the Access wiki moderators. Original article by Brian M
|
Summing elapsed time that could go over 24 hours
| This page was last modified 02:02, 9 February 2012. This page has been accessed 1,212 times. Disclaimers |