Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Sep 2001
    Stuck at work..., Missouri, USA
    Thanked 0 Times in 0 Posts
    My wife just started a new job (yeah!) and they have her using an Excel time sheet.

    She asked me if I could help her get it to total the times, but I'm having a bit of trouble.

    The columns she fills out are:
    In, Out, In, Out

    There are 2 Sub-totals. One for the first set of In/Out and one for the second set.

    There is then a Total, the sum of the 2 sub totals.

    All in all, it looks like this:
    In Out SubTotal1 In Out SubTotal2 Total

    Now, I could do this easily if I could get her to do military time, but no dice.

    How can I set it up so that the SubTotals and Total work if she doesn't use military time?

    An example of a shift she worked is:
    In 11:00
    Out 2:00
    In 2:30
    Out 6:00

    That makes SubTotal1 = 3 and SubTotal2 = 3.5 with a total of 6.5.

    If it helps, the store is only open 8-6, so she never crosses midnight.

    Any help is greatly appreciated!
    <font face="Comic Sans MS">Morgan Erickson</font face=comic>
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>-From <img src=/S/flags/Colorado.gif border=0 alt=Colorado width=30 height=18> but living in <img src=/S/flags/Missouri.gif border=0 alt=Missouri width=30 height=18>...and working in Kansas.

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Redcliff, Alberta, Canada
    Thanked 5 Times in 5 Posts
    If one isn't using 24 hour time, then you must use AM/PM so that excel knows what is going on.

    so if she enters 11:00 am and 2:00 pm, your calculations should be fine.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    WS Lounge VIP
    Join Date
    Dec 2009
    Thanked 1,117 Times in 1,040 Posts
    You could use an if statement.
    if (IN > OUT, IN+0.5-OUT, IN-OUT)

    0.5 = 12 hours in time format.

    cheers, Paul

Posting Permissions

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