formula?
=Total_Sales/(Total_Hours*24)
so if you have sales in A2 and Hours in B2 (using the time format hh:mm)
=A2/(B2*24)
format as currency or general
--
Regards,
Peo Sjoblom
"help!!!" wrote in message
...
what is the formula to calculate sales per hour.
|