How do I calculate total pay from [h]:mm times pay rate per hour?

G

Guest

Instead of multplying, say, 7.5 (for 7 and 1/2 hours) times an hourly pay
rate of, say, $12.50 to arrive at a total pay of $93.75 - How would I do
the same calculation using 7:30 (for 7 and 1/2 hours in the hh:mm format) to
get the proper result in the total pay cell?
 
G

Guest

Thanks. Sorry I asked this question twice (again in another group). Didn't
know where I was at.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I calculate total pay from pay rate times hours and minutes 4
How do I calculate total hours by rate of pay? 1
Construct staff pay timesheet 1
keep old cell value and new cell value 2
Calculate the total overlapping time of multiple tasks, excluding non-working times 1
Calculate total using hrs by cost per hr 5
calculating hourly rate using [h]:mm:ss format 1
automating pay rate changes 2

Top