# Calculating percent of hours worked by shift using military time

1. ## 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?  Register To Reply

2. ## 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.   Register To Reply

3. ## 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  Register To Reply

4. ## Re: Calculating percent of hours worked by shift using military time Originally Posted by Jacc If you post a workbook with some sample data it will be much easier to help you. 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  Register To Reply

5. ## Re: Calculating percent of hours worked by shift using military time Originally Posted by popipipo  ``Please Login or Register  to view this content.``
Try this
Why have you chosen to use 1/3?  Register To Reply

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

1/3 of a day is 8 hours  Register To Reply