Percentage between two given times in Excel
 

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? :)

Percentage between two given times in Excel
 

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.

--
Biff
Microsoft Excel MVP


"offdah3z" wrote in message
...
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? :)

Percentage between two given times in Excel
 

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.

"offdah3z" wrote:

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? :)