Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating payroll cost
Hello all....I am trying to calculate a total payroll cost off a cell in
which I have calculated the total time worked during the day by an employee. I can easily calculate the total time worked, but of course the problem is Excel sees the calculated time difference as a decimal instead of a real number, so the total payroll cost is incorrect. Can anyone tell me how to get Excel to see my calculated time difference as a true number instead of a decimal so I can multiply it by an hourly rate and receive a payroll cost? Thank you! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating payroll cost
Multiply your time value by 24. Excel stores times as a fraction of a
24 hour day (e.g., 6:00 = 0.25, 12:00 = 0.5, 18:00 = 0.75, etc,) so multiplying by 24 gives you the number of hours. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Thu, 12 Feb 2009 09:47:01 -0800, MRH wrote: Hello all....I am trying to calculate a total payroll cost off a cell in which I have calculated the total time worked during the day by an employee. I can easily calculate the total time worked, but of course the problem is Excel sees the calculated time difference as a decimal instead of a real number, so the total payroll cost is incorrect. Can anyone tell me how to get Excel to see my calculated time difference as a true number instead of a decimal so I can multiply it by an hourly rate and receive a payroll cost? Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Payroll calculating | New Users to Excel | |||
Calculating cost of product | Excel Worksheet Functions | |||
Calculating Monthly Payroll Taxes | Excel Worksheet Functions | |||
Calculating cells cost hours | Excel Discussion (Misc queries) | |||
calculating payroll | Excel Discussion (Misc queries) |