Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
time percent
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
time percent
Not sure that I follow what you are asking but if you mean that the
employee's working day is 7:30:00 and for 1:00:00 of that day they are idle then the idle time is =Working day/Idle time and the percentage of time actually worked is =1-Working day/Idle time both cells formatted as percentage. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings with @tiscali.co.uk "dpb0180" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
time percent
You calculate percentages of time the same way you calculate the percentage of
numbers. If your numbers were 7.5 and 1, the percentage not ready is 1/7.5, the percentage ready is (7.5-1)/7.5 It's the same calculation for times, as in: a5 = (time(7,30,0)-a1)/time(7,30,0) .. Just make sure a5 is formatted as percent. -- Regards, Fred "dpb0180" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS | Charts and Charting in Excel | |||
synchronizing timestamp feature with time on video software. | Excel Discussion (Misc queries) | |||
formula to determine time range overlap? | Excel Discussion (Misc queries) | |||
Hot key for time? | Excel Worksheet Functions | |||
time sheet drop down lists | Excel Discussion (Misc queries) |