Hey everybody, I'm having a problem. I have a production "template" that
calculates how many tasks a worker has completed since every task holds a
time weight. It totals all of the tasks up for the week into a time in
(hh:mm) format. The supervisor inputs the amount of time the worker was
actually working, and a seperate cell is supposed to calculate the percentage
between the two numbers.

Cell A1 is the total amount of time taken by the task weight. Cell B1 is
where the supervisor enters the amount of time worked for the week, and cell
C1 should give you the difference in percentage.

I've been having issues where the final percentage is not adding up. It
seems the formatting may also be a culprit. Would it be simplier to have B1
be entered manually as a decimal time rather than hh:mm? (24.5 rather than
24:30)

For some reason, B1/A1 with a percentage format on C1 is not working for me
in this situation.

help? :)