M
MRH
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!
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!