Figure Payroll...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to figure payroll in Microsoft Excel. I have the hours figured
accurately. I have the wages entered. But when I try to multiply the two to
get a daily (and weekly) gross pay, it gives me a very small number from
multiplying the time (hours and minutes) by the serial number rather than the
hours and minutes. This gives me a total of roughly $13.00 for 55 hours of
work @ $8.00 per hour. This isn't correct, but I cannot figure out how to
get it to do the calculations correctly. Does anyone know how to do this?
Thank you,
Walt
 
In Excel, a time is a fraction of a day (eg, 12 hours is 0.5 (days)). To get
hours, multiply the time by 24.
 
Thank you, Fred, for the information. However, when I did this, it added 6
minutes to the actual time. (49:09 became 49:15). Is there a way to fix
this problem? Thank you, again.
 
Look again. The time, 49:09, when multiplied by 24 becomes 49.15 - forty
nine and fifteen hundredths hours.

Likewise 49:15 becomes 49.25, 49:30 becomes 49.5, etc.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating payroll cost 1
I need calculated time in a "real number" format 2
adding actual numbers in columns 3
How do I setup a formula for payroll deductions in excel 1
Excel if Functions 1
Payroll lookup 1
Help needed on payroll formula 2
Payroll verification hrs and time off 6

Back
Top