Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003

    Unanswered: tracking hours for payroll purposes

    How might I set up a spreadsheet that I could give to a payroll auditor in which they could input an employee's starting (e.g., 7:00 am) and finish time, deduct lunch time (e.g., 1:00 for one hour, 0:45 for 45 minutes), and get the following outputs:

    -total hours/minutes
    -total "straight" hours/minutes
    -total "overtime"/minutes

  2. #2
    Join Date
    Jul 2003
    All done by formatting the cells and using simple subtraction -

    The start and end times you can use the cell format Time 13:00

    for lunch use h:mm:ss but rmember to type in 00:45:00

    the 17:00 - 7:00 will give 10 hours (format the result cell too !)

    10 hours - the cell with 00:45:00 will give 9:45

Posting Permissions

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