Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula?
what is the formula to calculate sales per hour.
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |