I am trying to find the total hours worked for my individual employees with multiple log-in and log-out times. My service guys go from business and to business and work, but I need to pay them for their travel time as well. I have 4 employees and I need my spreadsheet to be able to recognize the name (I tried VLOOKUP and SUMIF), then look at the earliest log-in time, then the latest log out time, and tell me how many hours they worked for that day. Then I need it to add up all the time worked during the week. I know how to calculate the times they work from log-in to log-out, but then their travel time between jobs gets lost. HELP!!! I've attached a copy of what I'm currently working with. ANY help would be appreciated!
Bookmarks