ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Divergent units in formulas (https://www.excelbanter.com/excel-discussion-misc-queries/39681-divergent-units-formulas.html)

Brian

Divergent units in formulas
 
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???????

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!
================================================== ===

"Brian" wrote in message
...
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???????




All times are GMT +1. The time now is 08:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com