how to simplified data containing hourly and daily for prediction?

i have a big problem here regarding to the question above. i have a lot of data which consist of hourly and daily data to predict a target output of 24 hours solar radiance. i have 3 variables with 24 hours data respectively. anyone can help me how to rearrange a time-series data in excel and import the data into matlab workspace? picture below shows an example of my data consists of 3 inputs with 24 hours respectively and a target output with 24hours prediction.

Answer 1

[Star Strider]

Use the xlsread function to read the file. I cannot help you with your Excel programming.

[Mariam Jamilah Md Nujid]

okay sir, thank you for the answered. but the main problem is the time-series data. btw, thank you again :)

[Star Strider]

What is the problem with the time series data?