Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? :) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? :) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count text appear how many times & put in respec col??eg 1st times | Excel Discussion (Misc queries) | |||
Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
Calculation of hourly rate times hours times 1.5 | Excel Worksheet Functions | |||
How are relay leg times or driving times entered and totaled? | Excel Worksheet Functions | |||
Charting and analyzing Times' times data for trends | Excel Discussion (Misc queries) |