Time as a Duration
By Richard Rost 3 years ago
Display Time as a Duration in Hours / Minutes
Microsoft Access doesn't have a native time format that you can use to enter a duration such as 105 hours and 23 minutes. This is especially useful in some professions, like airplane mechanics who have to note how many "flight hours" a plane has on it. In this TechHelp video, I'll show you how to handle it.
We will learn how to perform the calculations to determine total hours and/or minutes, the Round function, and some string manipulation functions like Left, Right, and InStr to deal with the non-standard time format.
There is no Extended Cut for this video.
You can download the database I built here: Access Duration Times ZIP
Subscribe to Time as a Duration
Get notifications when this page is updated