Have you tried joining the two tables on the date field? If they are in separate Excel files you will need to put both sheets in same Excel file to join them.
price*KWH- is per hour
price*KHW* 24*7 weekly
you need to clik,data,edit relationship and select common filed in both i.e Date and Hour,Date and Time.
someone correct if this is wrong