Dividing time by whole numbers (for productivity per hour)

[Tom_J_W]

Hey,

I'm trying to work out the productivity of something per hour but I'm having a bit of trouble with dividing time in Excel.

Basically I've got

A1 = # of Sales (e.g. 5)
A2 = Total time worked (e.g 07:36:00)

I want C1 to show me how many Sales are made per hour.

Any advice?

[FDibbins]

try this...

=A1/A2/24

format as number