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.

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"Wakt" wrote in message
...
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

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.

"Fred Smith" wrote:

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.

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"Wakt" wrote in message
...
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

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.


In article ,
"Wakt" wrote:

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.

Oops!!! You're right... It does... Sorry.
Walt

"JE McGimpsey" wrote:

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.


In article ,
"Wakt" wrote:

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.