converting time worked to dollars earned.

[gail]

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....

[JE McGimpsey]

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 <[email protected]>,
"gail" <[email protected]> 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....

[gail]

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 <[email protected]>,
> "gail" <[email protected]> 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....
>