How do I calculate total pay from pay rate times hours and minutes
 

Instead of using, say, 7.5 for 7 and 1/2 hours, how do I calculate total pay
for 7:30 times, say, an hourly pay rate of $8.25 an hour? Multiplying 7.5
times $8.25 equals $61.87. How do I do the same calculation using 7:30 (i.e.
hh:mm) instead of 7.5 for 7 and 1/2 hours? Is there a special format for the
result (total pay) cell that will yield the correct answer of $61.87?

Answer: How do I calculate total pay from pay rate times hours and minutes
 

How do I calculate total pay from pay rate times hours and minutes
 

If A1=Time (hh:mm) and B1=Hourly Rate, then in C1

=A1*24*B1

"Rufus" wrote:

Instead of using, say, 7.5 for 7 and 1/2 hours, how do I calculate total pay
for 7:30 times, say, an hourly pay rate of $8.25 an hour? Multiplying 7.5
times $8.25 equals $61.87. How do I do the same calculation using 7:30 (i.e.
hh:mm) instead of 7.5 for 7 and 1/2 hours? Is there a special format for the
result (total pay) cell that will yield the correct answer of $61.87?

How do I calculate total pay from pay rate times hours and minutes
 

.... and format C1 as currency

"Rufus" wrote:

Instead of using, say, 7.5 for 7 and 1/2 hours, how do I calculate total pay
for 7:30 times, say, an hourly pay rate of $8.25 an hour? Multiplying 7.5
times $8.25 equals $61.87. How do I do the same calculation using 7:30 (i.e.
hh:mm) instead of 7.5 for 7 and 1/2 hours? Is there a special format for the
result (total pay) cell that will yield the correct answer of $61.87?

How do I calculate total pay from pay rate times hours and min
 

Please don't post to different NGs to avoid people responding when another
posting has been answered.

"Toppers" wrote:

... and format C1 as currency

"Rufus" wrote:

Instead of using, say, 7.5 for 7 and 1/2 hours, how do I calculate total pay
for 7:30 times, say, an hourly pay rate of $8.25 an hour? Multiplying 7.5
times $8.25 equals $61.87. How do I do the same calculation using 7:30 (i.e.
hh:mm) instead of 7.5 for 7 and 1/2 hours? Is there a special format for the
result (total pay) cell that will yield the correct answer of $61.87?

How do I calculate total pay from pay rate times hours and min
 

I may have posted to different NG with same question the first time because
when I got in here I sent off my question into never-never land and didn't
know where it ended up. Haven't used this forum in a long, long time. Anyway,
THANKS !

"Toppers" wrote:

Please don't post to different NGs to avoid people responding when another
posting has been answered.

"Toppers" wrote:

... and format C1 as currency

"Rufus" wrote:

Instead of using, say, 7.5 for 7 and 1/2 hours, how do I calculate total pay
for 7:30 times, say, an hourly pay rate of $8.25 an hour? Multiplying 7.5
times $8.25 equals $61.87. How do I do the same calculation using 7:30 (i.e.
hh:mm) instead of 7.5 for 7 and 1/2 hours? Is there a special format for the
result (total pay) cell that will yield the correct answer of $61.87?