How to use IF statements to calculate power usage and cost

Hello,

I am trying to use IF statements (I think this is correct) to work out power usage of a machine at certain times to therefore workout the cost associated with running this.

Please see the photos with the information. I am unsure of the formula to write to work out the amount of time the machine is running between certain times (peak power times, off-peak times, etc).

The overall goal is to input the start and end kw/hr reading as well as the start and finish time of the machine. Excel will then do the rest calculating the time in each period (peak, off-peak, etc) and therefore a total cost for that day.

Thanks to HansVogelaar for responding to a previous post (forgot my login details and therefore have a new Microsoft Account) which had an answer, but I could not translate that work into what I am trying to achieve above. Sorry I didn't get a chance to say thank you!

Hopefully someone can help me out.

Thanks in advance.