+ Reply to Thread
Results 1 to 3 of 3

Military in and out formula

  1. #1
    Registered User
    Join Date
    03-01-2012
    Location
    Guthrie ok
    MS-Off Ver
    Excel mac 2011
    Posts
    1

    Military in and out formula

    On my spreadsheet I have when I clocked in and when I clocked out, there may be multiple of these such as the line below...
    DATE IN OUT IN OUT IN OUT IN OUT time
    Wed 1 8:30 13:00 15:30 17:30 6.50

    I want to know the formula that I can use that will calulate the total time for me. without haveing to do it manually. I know it's possible, I am just not the best with formulas.

    Can you help.

  2. #2
    Forum Guru tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Military in and out formula

    shaylajo,

    Welcome to the forum!
    Attached is an example workbook based on the criteria you described.
    In cell H2 is this formula (cell is formatted as General):
    =SUM(C2-B2,E2-D2,G2-F2)*24
    Attached Files Attached Files
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    02-28-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: Military in and out formula

    I assume that you will be checking in 2x a day and out 2x per day.
    you can take the sum of the difference between the first 2 time and the second 2 times please see attached sheet.

    Hope this helps
    +HZ
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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