+ Reply to Thread
Results 1 to 6 of 6

Calculating percent of hours worked by shift using military time

  1. #1
    Registered User
    Join Date
    06-11-2015
    Location
    NE US
    MS-Off Ver
    2013
    Posts
    70

    Calculating percent of hours worked by shift using military time

    Let's say Employee #1 works 08:16 hours to 16:45 hours and I get a difference of 08:29 hours using formula =mod(B1-A1, 1), how do I calculate a percent of their time worked in an 8 hour shift? All of my cells for this formula are formatted using [hh]:mm

    My goal is to compare amount of time worked for several different staff but it must be in percentage form. I have also added a column near the column containing the 'difference of time' values, using the formula =A1*24*60, to convert the hh:mm format into actual minutes (e.g., 08:16 equals 496 minutes).

    Anybody care to chime in?

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,570

    Re: Calculating percent of hours worked by shift using military time

    If you post a workbook with some sample data it will be much easier to help you.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  3. #3
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,903

    Re: Calculating percent of hours worked by shift using military time

    how do I calculate a percent of their time worked in an 8 hour shift?
    Please Login or Register  to view this content.
    Try this
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  4. #4
    Registered User
    Join Date
    06-11-2015
    Location
    NE US
    MS-Off Ver
    2013
    Posts
    70

    Re: Calculating percent of hours worked by shift using military time

    Quote Originally Posted by Jacc View Post
    If you post a workbook with some sample data it will be much easier to help you.
    I've loaded an image.

    The column with the question marks is what I am trying to figure out, and two columns preceding that one use the formulas I originally posted.Capture.PNG

  5. #5
    Registered User
    Join Date
    06-11-2015
    Location
    NE US
    MS-Off Ver
    2013
    Posts
    70

    Re: Calculating percent of hours worked by shift using military time

    Quote Originally Posted by popipipo View Post
    Please Login or Register  to view this content.
    Try this
    Why have you chosen to use 1/3?

  6. #6
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,903

    Re: Calculating percent of hours worked by shift using military time

    1/3 of a day is 8 hours

+ 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] Calculating hours worked for 3rd shift
    By tiffany04530 in forum Excel General
    Replies: 10
    Last Post: 11-30-2012, 01:56 PM
  2. Replies: 0
    Last Post: 05-14-2012, 05:36 PM
  3. Calculating basic hours worked, between a time range and premium hours worked
    By RoyLittle0 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-07-2012, 06:59 AM
  4. Replies: 0
    Last Post: 01-05-2012, 06:23 AM
  5. Calculating Hours Worked from Shift Begin and Shift End
    By lukeflegg in forum Excel General
    Replies: 5
    Last Post: 08-12-2011, 03:25 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