I am struggling as a total newbie to the excel formula area. I need to
convert the hours and minutes to the dollars earned. The worksheet is set
up to calcute the total number of hours and minutes worked in one month
period. the total columns at the bottom adds the weeks totals into total
hours and minutes worked. So That much seems to work well. but when i try
to put a salary such as 12.00 per hour times the amount of time worked I
struggle. I have tried converting the times to hours alone and minutes alone
and then multiplying by 12 but it doesn't work for me.? can anyone help?
thank you.....for any advice you can give....

XL stores times as fractional days, so if you've got your sum as an XL
time (e.g., 40:00), then multiply by 24 to get hours:

A1: 40:00
A2: 12.00
A3: =A1*24 * A2

to give you the wages earned in A3.

In article ,
"gail" wrote:

I am struggling as a total newbie to the excel formula area. I need to
convert the hours and minutes to the dollars earned. The worksheet is set
up to calcute the total number of hours and minutes worked in one month
period. the total columns at the bottom adds the weeks totals into total
hours and minutes worked. So That much seems to work well. but when i try
to put a salary such as 12.00 per hour times the amount of time worked I
struggle. I have tried converting the times to hours alone and minutes alone
and then multiplying by 12 but it doesn't work for me.? can anyone help?
thank you.....for any advice you can give....

Thank you for your time and effort......i will give that a try. I really
enjoy learning new ways to make this work. =o]

"JE McGimpsey" wrote:

XL stores times as fractional days, so if you've got your sum as an XL
time (e.g., 40:00), then multiply by 24 to get hours:

A1: 40:00
A2: 12.00
A3: =A1*24 * A2

to give you the wages earned in A3.

In article ,
"gail" wrote:

I am struggling as a total newbie to the excel formula area. I need to
convert the hours and minutes to the dollars earned. The worksheet is set
up to calcute the total number of hours and minutes worked in one month
period. the total columns at the bottom adds the weeks totals into total
hours and minutes worked. So That much seems to work well. but when i try
to put a salary such as 12.00 per hour times the amount of time worked I
struggle. I have tried converting the times to hours alone and minutes alone
and then multiplying by 12 but it doesn't work for me.? can anyone help?
thank you.....for any advice you can give....

I got a lot of my begginer help on this site... cool
They teach you by making a, Time sheet, Invoice and cheek book from
scratch on Windows media Player very cool

www.MDOTutorials.com


--
Route2391
------------------------------------------------------------------------
Route2391's Profile: http://www.excelforum.com/member.php...o&userid=26774
View this thread: http://www.excelforum.com/showthread...hreadid=397400