Divergent units in formulas

B

Brian

I am trying to multiply the number of hours that my employees work with their
hourly wage and come up with a dollar number for each employee per day. The
hours calculation is based upon four different conditional formulas, but in
the last calculation there is a conflict of units (dollars/hours). I need to
be able to get a dollar value from this calculation. Any ideas???????
 
R

RagDyeR

Format a column to "General" or "Numbers", and then take the total time and
multiply it by 24 to return decimal hours that can *then* be multiplied by
the pay rate per hour to obtain total dollars.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I am trying to multiply the number of hours that my employees work with
their
hourly wage and come up with a dollar number for each employee per day. The
hours calculation is based upon four different conditional formulas, but in
the last calculation there is a conflict of units (dollars/hours). I need to
be able to get a dollar value from this calculation. Any ideas???????
 
Top