dividing with time function

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I summed up a cell using the sum formula, then formatted it with [h]:mm.
Now i need to divide a real # with this formatted cell. I need to find a #
of tasks per hour, is this possible?
 
Hi Steve
just multiply the time with 24. So in your case use the following
(assumption A1: your time; A2: number of tasks)
=A2/(A1*24)
format this resulting cell as 'General' or 'Number'

HTH
Frank
 
Back
Top