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?