dividing with time function

[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?

 

[Frank Kabel]

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