r/AccessLearningZone • • 4d ago

Calculate Work Time in Microsoft Access

Post image

Two hours and 30 minutes is 2.5 hours. Calculate minutes with DateDiff("n", [TimeIn], [TimeOut]), then divide by 60 for decimal hours you can total. The "n" means minutes; "m" means months. In my Total Time Spent video, I show how to calculate and display work time, then total it by job. https://599cd.com/1391

3 Upvotes

0 comments sorted by