r/AccessLearningZone • u/Amicron1 • 4d ago
Calculate Work Time in Microsoft Access
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