Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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??????? |
#2
|
|||
|
|||
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??????? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
Need Formulas for counting multiple conditions | Excel Worksheet Functions | |||
Problem with named formula's | Excel Worksheet Functions | |||
Formulas | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |