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?

Originally Posted by Jacc

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

Originally Posted by popipipo

Please Login or Register  to view this content.

Try this

Why have you chosen to use 1/3?