+ Reply to Thread
Results 1 to 4 of 4

Calculating time to track work hours

  1. #1
    Registered User
    Join Date
    07-27-2007
    Posts
    19

    Calculating time to track work hours

    I can't figure out how to do a proper formula for calculating time. For instance I have one column that says "Time In", the next is "Time Out" and the other is "Lunch Time". My calculation needs to be this:

    Find the total hours between the Time In and Time Out and then Minus the lunch time to get total hours worked for the day.

    The only way I can get this to work is using 24 Hour time format. Is there another way?
    Last edited by halvy52; 07-28-2009 at 08:58 PM.

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,887

    Re: Calculating time to track work hours

    The typical way to calculate hours worked with a break would be to have four cells, for example:
    A1 = Time In (beginning of day)
    A2 = Time Out for Lunch
    A3 = Time In from Lunch
    A4 = Time Out (end of day)

    You would then use the formula:

    =(A2-A1)+(A4-A3)

    Hope that helps!

  3. #3
    Registered User
    Join Date
    07-27-2007
    Posts
    19

    Re: Calculating time to track work hours

    I'm assuming I would still have to use 24 hour time? No big deal but just wondering.

  4. #4
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,887

    Re: Calculating time to track work hours

    No need to use 24 hour time as long as you're entering your in/out times as AM and PM.

    In: 7:00 AM
    Out: 12:00 PM
    In: 1:00 PM
    Out: 5:00 PM

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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