I have two time zones 07:00 to 00:00 is day rate and 00:00 to 07:00 is night rate.
Electricity is charged at 10.3456 day rate and 6.3333 night rate.
My lights come on in cell f3 and off in cell g3 so:-
f3=20:45 and g3=22:00 this equal 1.25 hours on time based on =IF(G3>F3,G3-F3,24-F3+G3) also
f3=07:00 and g3=01:00 which is 18 hours on time based on the formula above.
f3=20:30 and g3=02:30 which is 6 hours on.
I also have lights running 24/7
How do I determine what portion of the hours are day rate and night rate to be able to calculate the cost of running the lights.
Thanks in advance.
Bookmarks