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.
Yeah it's been in the high 90s here in South Florida for the past week and my air conditioning is struggling to keep up so I added a few fans to my office. I didn't realize that you can hear them in the video. And yes there was some soft music playing in the background that I didn't think would make it into the video.�Apparently my microphone is stronger than I thought. And of course I didn't hear any of this because of the fans that are running in my office. I'll be more careful in the future. Still waiting on the repairman to get my AC serviced. I've got it set at 67 and the house is running close to 80. Welcome to summers in South Florida.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.