Calculating hours worked with an hourly rate

G

Graham

I would like to calculate eg 40:30 at an hourly rate of £6.

Could someone please advise
 
F

Frank Kabel

Hi
if this value is in A1 use
=A1*24*6
and format the resulting value as 'Number/Currency)
 

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

Calculate After hours 3
calculate overtime at 2 different rates 5
Payout based on hours rate and designation 6
advanced 'if' multiply 2
Vacation accrual based on years with rollover 1
Calculating time for 3rd shift 4
Calculation of hourly rate times hours times 1.5 1
Simple Time sheet, calculate OT 2

Top