multiply time with hourly rate

M

Mike

I need to produce a costed staff rota and if nessessary
will have columns for "start time" hh:mm, "finish time"
hh:mm and a calculation column showing "worked hours"
hh:mm.

Once the hours worked have been calculated this has to be
multiplied by an hourly pay rate, ie hh:mm x £x.xx, this
has two different formats.

How do I format a cell to show total pay as £x.xx?

Thanks
Mike
 
P

Peo Sjoblom

Total pay is

=(End_Time-Start_Time)*24*payrate

format as £#,##0.00

--

Regards,

Peo Sjoblom

I need to produce a costed staff rota and if nessessary
will have columns for "start time" hh:mm, "finish time"
hh:mm and a calculation column showing "worked hours"
hh:mm.

Once the hours worked have been calculated this has to be
multiplied by an hourly pay rate, ie hh:mm x £x.xx, this
has two different formats.

How do I format a cell to show total pay as £x.xx?

Thanks
Mike
 

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 [h]:mm times pay rate per hour? 2
Start time = rate..... 3
How do i multiply an hourly rate by hours in Excel? 2
How do I calculate total pay from pay rate times hours and minutes 4
how to multiply h:mm value by an hourly $ rate 2
Calculation of hourly rate times hours times 1.5 1
calculating hourly rate using [h]:mm:ss format 1
formula question 1

Top