formula?
 

what is the formula to calculate sales per hour.

formula?
 

One way:

If hours is in integer format rather than time format (e.g., 8, not
8:00)
A1: <sales
A2: <hours

then

A3: =A1/A2


If instead hours is in time format (8:00), XL stores times as
fractional days, so you need to multiply by 24:

A3: =A1/(A2*24)

In article ,
"help!!!" wrote:

what is the formula to calculate sales per hour.

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.

formula?
 

thankx a mil. j.e.!!!
-----Original Message-----
One way:

If hours is in integer format rather than time format
(e.g., 8, not
8:00)
A1: <sales
A2: <hours

then

A3: =A1/A2


If instead hours is in time format (8:00), XL stores
times as
fractional days, so you need to multiply by 24:

A3: =A1/(A2*24)

In article ,
"help!!!" wrote:

what is the formula to calculate sales per hour.
.