Generate Year 2016 Weekday/Weekend date with time

[Onovo]

Please I want to generatedate data for weekdays and weekend respectively. The date starts from 01/01/2016 and ends on 31/12/2016. The weekday contains only weekdays date and the weekend contains weekend dates. each dates for weekdays/weekend should have time format such that the time begins at 0.00 and end at 23.00 (i.e. 24 data point for the time associated to each date. Also, I would like to know how to calculate sum and average for each date across the different weekdays and weekends. Such that on 01/01/2016 which is a Friday and a weekday of 2016 would have the following format, and so on, thank you:

01/01 00:00​

01/01 01:00​

01/01 02:00​

01/01 03:00​

01/01 04:00​

01/01 05:00​

01/01 06:00​

01/01 07:00​

01/01 08:00​

01/01 09:00​

01/01 10:00​

01/01 11:00​

01/01 12:00​

01/01 13:00​

01/01 14:00​

01/01 15:00​

01/01 16:00​

01/01 17:00​

01/01 18:00​

01/01 19:00​

01/01 20:00​

01/01 21:00​

01/01 22:00​

01/01 23:00​

 

[alansidman]

crossposted: 2016 Weekday/Weekend with time

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: 2016 Weekday/Weekend with time
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.