+ Reply to Thread
Results 1 to 4 of 4

Formula tp ca;culate hours worked using military hours and standard minutes

  1. #1
    Registered User
    Join Date
    02-24-2014
    Location
    Everett, Washington USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Formula tp ca;culate hours worked using military hours and standard minutes

    I am looking for a formula to calculate totals time worked for the day using military hours and standard minutes.
    For example "In" at 8:00 "Out" at 11:30 "In" at 12:00 "Out" at 4:30. The formula I am using does not convert the minutes.
    Here is the formula I am using:

    =((D11-C11)+(F11-E11))/100

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Formula tp ca;culate hours worked using military hours and standard minutes

    I don't see what the /100 is for?

    It should just be a straight addition of the 2 seperate time differences.
    =(D11-C11)+(F11-E11)

  3. #3
    Registered User
    Join Date
    02-24-2014
    Location
    Everett, Washington USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Formula tp ca;culate hours worked using military hours and standard minutes

    The 100 is to convert in to total hours worked for the day in standard format.
    Using the formula I currently am using returns a total hours for the day as 7.6 when it should be 8

  4. #4
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Formula tp ca;culate hours worked using military hours and standard minutes

    I still don't understand how deviding by 100 converts a value to a time or vice versa.
    what are the actual values in C11:F11 ?
    Are they just numbers like 8 11.5 12 16.5 ?

    Can you post a sample book?

+ 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. [SOLVED] Need formula to auto-deduct 30 minutes from hours worked if over 6 hours
    By BluesJunkie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-06-2014, 03:07 PM
  2. Replies: 4
    Last Post: 02-12-2013, 07:01 AM
  3. Replies: 2
    Last Post: 02-11-2013, 02:26 PM
  4. Replies: 5
    Last Post: 03-04-2012, 06:00 PM
  5. Converting hours and minutes in military time to minutes
    By Argile79 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-13-2010, 02:42 PM

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