I work for a trucking company and all of the trucks have onboard computers with GPS tracking, recently the company decided to have the local drivers clock in and out on the OBC that way they also have the location of the unit when the driver clocks in or out. My question is they want a report of each driver and the hours worked for each day. I tried using the SUBDUR function for the two time stamps but the result for the hours worked is not exactly correct it can be off by a few tenths of a minute. I tried using the hour function but will not show over whole hours so I used the minute function and then divide to total minutes by 60 but that is off by tenths sometimes the time is high and others are low. Below are the calculations
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.
Your password has been sent to:email@example.com
To follow this tag...
Thanks! We'll email you when relevant content is added and updated.
Share this item with your network: