hello,

I am trying to get a formula to calculate the percent of time used.

lets say an employee works 07:30:00 in a day and for 01:00:00 (range of
15min incriments a1 - a4) of that day they were not ready what percentage is
the difference.

result to be in cell a5