Hello
I have a grid with hourly data. For each day of the month. Hours ending
1-24 in cells C2:Z2 and date in B2:B33. I am trying to convert the tabular
data to columnar data. In B41:B785 I have the date/time dd/mm/yyyy hh:mm. I
can use INDEX(My_Range,DAY($B41),HOUR($B41)) for hours 1-23 but it doesnt
work in 24. I could change my table to 0-23 and it would work but I would
rather not do that.
Any ideas?
Thanks!