Calculating Node aging using MACRO

Dear Team,

We are getting raw data with node down time and uptime. And we need to calculate the down time using the data got from server.

Manually we are arranging the data with selected time and sorting the data and using some formulas we are arranging the report( Sample attached with name Time Duration After arranging)

But now we attached the raw data also( Time Duration Before arranging). Can any one help us to get the macro for arrange and time calculation.

Regards,
Chaitanya Gowtham A