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