Hello,
Our company uses GPS data loggers to track workers in the field. our workers distribute flyers and are currently paid by the piece, soon to be paid by the hour. To be able to accurately pay them hourly, we need to be able to efficiently and accurately add up their total time worked and time not working (i.e. standing still) from start to finish. to achieve this, I was thinking that excel could count the total time between logs each day. Then, to calculate time not working within that total, excel could count time logs further apart than "XX" amount of seconds as time not working and provide us in the end with 3 totals. Total time per day working, total actual time working and total time not working. I've attached a sample of one of our GPS's logs in excel format. Is there any way of doing what we need with this data?
Thank you advance for your time and help.
Bookmarks