Hi Excel Masters, I have an issue with Excel`s formula that I am trying to solve quite long.

However, I have created working hours template which calculates time spent on work (start time - end time) multiplied by regular hourly rate.

Here is the trick - if any employee worked after 8 PM on any day, the hourly rate is changed. In that case, I am supposed to calculate how many hours employee worked after 8 PM and multiply it by corresponding rate.

I would highly appreciate your help.