Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm new to excel and trying to do wages for a small office by multipling
hours and minutes worked by an hourly rate of $16.25 per hour A1 is 39:15 ( 39 hours and 15 minutes - hours worked for the week) B1 is $16.25 ( $16.25 per hour worked) C1 I require the weekly wage I need to pay = A1*B1 but I don't get the correct answer |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
=A1*B1*24
"Carol (Australia)" wrote: I'm new to excel and trying to do wages for a small office by multipling hours and minutes worked by an hourly rate of $16.25 per hour A1 is 39:15 ( 39 hours and 15 minutes - hours worked for the week) B1 is $16.25 ( $16.25 per hour worked) C1 I require the weekly wage I need to pay = A1*B1 but I don't get the correct answer |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Carol, I ran the numbers you have given and C1= $636.19, I formated C1 for
accounting and the A1 as general, B1 was formated as accounting also; Hope this helps chefmike "Carol (Australia)" wrote: I'm new to excel and trying to do wages for a small office by multipling hours and minutes worked by an hourly rate of $16.25 per hour A1 is 39:15 ( 39 hours and 15 minutes - hours worked for the week) B1 is $16.25 ( $16.25 per hour worked) C1 I require the weekly wage I need to pay = A1*B1 but I don't get the correct answer |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Ummm... I think maybe you missed the hours and minutes thingy. The right
answer would be 637.81. 39 hours and 15 minutes times 16.25 per hour. In accounting format, that would actually make the hours worked 39.25, making a little, but oh so important when it's your paycheck, difference. :-) "chefmike" wrote: Hi Carol, I ran the numbers you have given and C1= $636.19, I formated C1 for accounting and the A1 as general, B1 was formated as accounting also; Hope this helps chefmike "Carol (Australia)" wrote: I'm new to excel and trying to do wages for a small office by multipling hours and minutes worked by an hourly rate of $16.25 per hour A1 is 39:15 ( 39 hours and 15 minutes - hours worked for the week) B1 is $16.25 ( $16.25 per hour worked) C1 I require the weekly wage I need to pay = A1*B1 but I don't get the correct answer |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
thanks BoniM
yes i see what you mean with the hour & minute thing, but is there a way that I can get excel to adjust those minutes into the correct format for multiplying the minutes into a fraction ?? Carol (Australia) "BoniM" wrote: Ummm... I think maybe you missed the hours and minutes thingy. The right answer would be 637.81. 39 hours and 15 minutes times 16.25 per hour. In accounting format, that would actually make the hours worked 39.25, making a little, but oh so important when it's your paycheck, difference. :-) "chefmike" wrote: Hi Carol, I ran the numbers you have given and C1= $636.19, I formated C1 for accounting and the A1 as general, B1 was formated as accounting also; Hope this helps chefmike "Carol (Australia)" wrote: I'm new to excel and trying to do wages for a small office by multipling hours and minutes worked by an hourly rate of $16.25 per hour A1 is 39:15 ( 39 hours and 15 minutes - hours worked for the week) B1 is $16.25 ( $16.25 per hour worked) C1 I require the weekly wage I need to pay = A1*B1 but I don't get the correct answer |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
=A1*B1*24
Carol - this formula does the math correctly without you having to multiply the minutes into a fraction first as long as the cells remain formated as time. Don't change the format to general or if it is general, change it to the time format. (Format, cells, time, choose 37:30:55). "Carol (Australia)" wrote: thanks BoniM yes i see what you mean with the hour & minute thing, but is there a way that I can get excel to adjust those minutes into the correct format for multiplying the minutes into a fraction ?? Carol (Australia) "BoniM" wrote: Ummm... I think maybe you missed the hours and minutes thingy. The right answer would be 637.81. 39 hours and 15 minutes times 16.25 per hour. In accounting format, that would actually make the hours worked 39.25, making a little, but oh so important when it's your paycheck, difference. :-) "chefmike" wrote: Hi Carol, I ran the numbers you have given and C1= $636.19, I formated C1 for accounting and the A1 as general, B1 was formated as accounting also; Hope this helps chefmike "Carol (Australia)" wrote: I'm new to excel and trying to do wages for a small office by multipling hours and minutes worked by an hourly rate of $16.25 per hour A1 is 39:15 ( 39 hours and 15 minutes - hours worked for the week) B1 is $16.25 ( $16.25 per hour worked) C1 I require the weekly wage I need to pay = A1*B1 but I don't get the correct answer |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks BoniM
i'll give that a go Carol Australia "BoniM" wrote: =A1*B1*24 Carol - this formula does the math correctly without you having to multiply the minutes into a fraction first as long as the cells remain formated as time. Don't change the format to general or if it is general, change it to the time format. (Format, cells, time, choose 37:30:55). "Carol (Australia)" wrote: thanks BoniM yes i see what you mean with the hour & minute thing, but is there a way that I can get excel to adjust those minutes into the correct format for multiplying the minutes into a fraction ?? Carol (Australia) "BoniM" wrote: Ummm... I think maybe you missed the hours and minutes thingy. The right answer would be 637.81. 39 hours and 15 minutes times 16.25 per hour. In accounting format, that would actually make the hours worked 39.25, making a little, but oh so important when it's your paycheck, difference. :-) "chefmike" wrote: Hi Carol, I ran the numbers you have given and C1= $636.19, I formated C1 for accounting and the A1 as general, B1 was formated as accounting also; Hope this helps chefmike "Carol (Australia)" wrote: I'm new to excel and trying to do wages for a small office by multipling hours and minutes worked by an hourly rate of $16.25 per hour A1 is 39:15 ( 39 hours and 15 minutes - hours worked for the week) B1 is $16.25 ( $16.25 per hour worked) C1 I require the weekly wage I need to pay = A1*B1 but I don't get the correct answer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how can I multiply number of hours and minutes by hourly rate? | Excel Worksheet Functions | |||
How can I add hours and minutes then multiply by cost per hour? | Excel Worksheet Functions | |||
How do I multiply an hourly cost by hours expressed in minutes? | Excel Worksheet Functions | |||
how do i multiply hours:minutes by a cash value? | Excel Worksheet Functions | |||
How do I multiply rate per hour by hours worked. | Excel Worksheet Functions |