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
 
Back
Top