Percentage between two given times in Excel

[offdah3z]

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?

 

[T. Valko]

For some reason, B1/A1 with a percentage

format on C1 is not working for me

Does that mean you're not getting the results you expect? If so, post
several representative samples of the input data along with the results you
get and the results you expect.

 

[Sheeloo]

In C1 put the formula you want like
=B1/A1
or
=(B1-A1)/B1 as per your requirement.

You need to format C1 as Number with required number of decimals.