Microsoft Access Times as a Duration HH:NN possibly exceeding 24 hours

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.

RESOURCES:
Time Formats: https://599cd.com/ACB3
Round Function: https://599cd.com/ACX8
InStr, Left, Right Functions: https://599cd.com/ACX14
CLng Function: https://599cd.com/XACX26

Your Questions Answered: https://599cd.com/TechHelp
FREE Access Level 1: https://599cd.com/Free101
$1 Access Level 2: https://599cd.com/1Dollar
Learning Connection 50% OFF: https://599cd.com/Connection

Richard's Blog: https://599cd.com/blog
Access Forum: https://599cd.com/AccessForum
Twitter: Twitter: LearningAccess

Email Me: [email protected]

https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...