What is the formula for determining something like 4 hours 17 minutes @ $22
per hour? HELP HELP!! Thanks!

Assuming your hour minute in this format
A1 =4:17
B1 =A1*24*22 (Format cell as General)

"Carolyn" wrote:

What is the formula for determining something like 4 hours 17 minutes @ $22
per hour? HELP HELP!! Thanks!

Your formula is helpful; however, here is what I have: 25 minutes @ $22/hour,
30 mins @ 22/hour, 35 minutes @ 22/hour. I need to compute each one
individually (25@22/hour), then add the dollar amounts to come up with a
payment. This is driving me crazy. I keep thinking it should be a common
equation or formula!!! I'm trying to do it on an Excel spreadsheet invoice.
Thanks so much!!

"Teethless mama" wrote:

Assuming your hour minute in this format
A1 =4:17
B1 =A1*24*22 (Format cell as General)

"Carolyn" wrote:

What is the formula for determining something like 4 hours 17 minutes @ $22
per hour? HELP HELP!! Thanks!

Are you saying that you have

25 minutes @ $22/hour

in one cell?

You should put the minutes as either

00:25

or 25

in separate cells, then you can use

=ROUND(A1*24*F1,2)

if the minutes are entered as 00:25, where A1 holds the time spent and
F1 the rate per hour

if you use 25 in A1

=ROUND((A1/60)*F1,2)

will both return the right amount


Regards,

Peo Sjoblom



Carolyn wrote:
Your formula is helpful; however, here is what I have: 25 minutes @ $22/hour,
30 mins @ 22/hour, 35 minutes @ 22/hour. I need to compute each one
individually (25@22/hour), then add the dollar amounts to come up with a
payment. This is driving me crazy. I keep thinking it should be a common
equation or formula!!! I'm trying to do it on an Excel spreadsheet invoice.
Thanks so much!!

"Teethless mama" wrote:

Assuming your hour minute in this format
A1 =4:17
B1 =A1*24*22 (Format cell as General)

"Carolyn" wrote:

What is the formula for determining something like 4 hours 17 minutes @ $22
per hour? HELP HELP!! Thanks!