# 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?

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.

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

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

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?

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

1/3 of a day is 8 hours

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

#### 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