Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
piviot calcualtions
I already use this formula = (C4-B4)*1440 so i am showing minutes
When I pivot the report i get the minutes to show up one time for each project, (which is what i want for billing) Because when i pay out, I pay by the units for each project. What i want to do is pivot the report, show the minutes, and have the minutes convert to units so it will speed up the billing process (two columns) 1 min to 7.5 minutes = .5 units - then up to 15 minutes = 1 full unit. Say i worked 533 minutes on a project i would like it to show me that i worked 35-1/2 units...... =CEILING(D4*1440/15,0.5) This didn't work... =CEILING(D12/15,0.5) nor this... the answer should be 35/1/2 units (9 hours) but the formula gives me 36, which is more than i can bill for I really appricate any help. -- thank you, Lorie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
piviot calcualtions
Hi Lorie
Try =FLOOR(D12/15,0.5) -- Regards Roger Govier "Lorie" wrote in message ... I already use this formula = (C4-B4)*1440 so i am showing minutes When I pivot the report i get the minutes to show up one time for each project, (which is what i want for billing) Because when i pay out, I pay by the units for each project. What i want to do is pivot the report, show the minutes, and have the minutes convert to units so it will speed up the billing process (two columns) 1 min to 7.5 minutes = .5 units - then up to 15 minutes = 1 full unit. Say i worked 533 minutes on a project i would like it to show me that i worked 35-1/2 units...... =CEILING(D4*1440/15,0.5) This didn't work... =CEILING(D12/15,0.5) nor this... the answer should be 35/1/2 units (9 hours) but the formula gives me 36, which is more than i can bill for I really appricate any help. -- thank you, Lorie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How would you show this in a piviot table? | Excel Discussion (Misc queries) | |||
Calculations in piviot tables | Excel Discussion (Misc queries) | |||
piviot table | Excel Worksheet Functions | |||
Piviot table help | Excel Discussion (Misc queries) | |||
Piviot Charts | Charts and Charting in Excel |