Excel Time Function Issue

[charizard]

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.

[jason.b75]

Try adding something like

+IF(end time > TIME(20,,),(end time - TIME(20,,))* difference)

Where start time refers to the cell with the start time and difference refers to the difference between the regular rate and the after 8 PM rate (not the actual after 8 PM rate).

[charizard]

It seems that your way is working! I nested your formula into IF and MOD function, and it`s showing the proper result! Thank you, you saved me lot of time.