Formula to Calculate usage by hour with sun

[learningexcelthankyou]

Hello,

I have an excel spreadsheet which gives % of kWh by hour and then I have sunrise and sunset times.

I need to know the overall % of kWh by hour for daylight hours (sunrise through to sunset) for each month of the year

I use the assumption I use the same power every minute of the hour so just need to know if I use say 3% of power between 5-6pm and sunset is 5:34 how much is of that percentage is between 5 and 5:34 and then done for the whole day