multiply time with hourly rate

  • Thread starter Thread starter Mike
  • Start date Start date
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
 
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
Hours to minutes jcs 5
Adding hours to a time 2
Calculate Wages 2
Change time h:mm to a decimal number based on hours 6
Formula to multiply time 4
Time x Rate 2
How do I calculate total pay from pay rate times hours and minutes 4

Back
Top