+ Reply to Thread
Results 1 to 7 of 7

Finding total hours worked for individual employees with multiple log-in and log-out times

  1. #1
    Registered User
    Join Date
    01-23-2014
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    3

    Finding total hours worked for individual employees with multiple log-in and log-out times

    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!
    Attached Files Attached Files

  2. #2
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Finding total hours worked for individual employees with multiple log-in and log-out t

    Hello and welcome.
    What's yours expect result?
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk

  3. #3
    Registered User
    Join Date
    01-23-2014
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Finding total hours worked for individual employees with multiple log-in and log-out t

    Quote Originally Posted by RobertMika View Post
    Hello and welcome.
    What's yours expect result?
    My expected result is to calculate the total time worked by the employee. If you look at the example for Monday on the first week, it says that Andrew worked from 03:00 AM to 08:00 AM, so the total time worked is 5 hours, but I'm not getting that when I add up the time under "Current Labor Hours" because I'm losing out on the 15 minutes of travel time between jobs. I would like to write a formula that recognizes the name in the "Auditor" column, then takes the max time from the "Time Out" Column associated with that name, and subtracts that time from the min time of the from the "Time In" column that corresponds with that employees name. This would give me the actual total time on the job. Once I have all the employees's time worked for the day, I need to find out what it is per week.

    If you could help, that would be amazing. I've tried to combine formulas to do this already (which you can probably tell based on my explanation), but I haven't had any luck getting a value.

    Thanks for your interest and help!

  4. #4
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Finding total hours worked for individual employees with multiple log-in and log-out t

    Put the results in the spreadsheet.

  5. #5
    Registered User
    Join Date
    01-23-2014
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Finding total hours worked for individual employees with multiple log-in and log-out t

    Quote Originally Posted by RobertMika View Post
    Put the results in the spreadsheet.
    I put the results in at the top. I hope this is what you are asking for.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    09-11-2013
    Location
    bangalore
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Finding total hours worked for individual employees with multiple log-in and log-out t

    Rather than working preciously on the excel sheets, I would recommend you to use some advanced tool where in the apps will be installed in the employees phone. And the time will be tracked automatically giving the result at the end of the day. One such tool that I am using as of now is the cloud based time tracking software and apps from Replicon where in where ever the employees go for work, the working time is tracked and feed in the app whose access is there with me as well. Just with one login I can keep track of the time they worked and I pay them accordingly.

  7. #7
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Finding total hours worked for individual employees with multiple log-in and log-out t

    Karen in this case it woudl be better to add a column for a break time.
    To create one off formula for your result would be very difficult.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Finding the First Login and Last Logout Times of Employees
    By ExcelTip in forum Tips and Tutorials
    Replies: 19
    Last Post: 02-17-2018, 01:47 AM
  2. [SOLVED] Finding Individuals on Multiple Sheets, then Calculating Hours Worked
    By LTExcel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-08-2012, 11:05 PM
  3. Replies: 5
    Last Post: 07-19-2012, 05:00 PM
  4. Replies: 6
    Last Post: 05-03-2010, 12:03 PM
  5. [SOLVED] List employees with hours worked, weekly, quarterly, and annually
    By Steve j. in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 02-18-2005, 10:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1