View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lorie Lorie is offline
external usenet poster
 
Posts: 30
Default Calculation problem

Start time and stop time are entered all month long to show minutes worked on
a project

Now it's the end of the month, we need to pivot our reports to show units
work on a project.

1 min to 7.5 minutes = .5 units - then up to 15 minutes = 1 full unit.

We can't round as we go along during the month.
It has to be after each project is totaled up at the end of the month
Only then can we round

Any Ideas?



--
thank you, Lorie