Time multiplied by currancy rate

[R.gillespie]

I am trying in setup a excel sheet where someone entered someone
* workday start time
* Time they arrive on Site
* TIme they leave site
* Time Home
to wokr out there pay, i have the sheet working out total times, but the
employees get paid different rates at different time of the day. So i want it
use the time on site collum and the time leaving site collum and work out the
pay for that day.
Travel Time is always the same rate. I will happily email anyone the excel
sheet if they can help.

Thanks
(e-mail address removed)

 

[Charles Chickering]

Do the different time zone/ pay rates stay the same for all employees? Feel
free to send me your spreadsheet. (e-mail address removed) (remove
nospam).