Divergent units in formulas

G

Guest

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???????
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top