Issue sorting by time in Excel

Hi all,

I’m working on a project where I scrape web data on flight and train information into an Excel doc. When I open the Excel doc it looks like everything has been entered properly. However, I would then like to sort the entire sheet from the earliest flight/train departure time to the latest. It seems Excel is not recognizing my Departure/Arrival Time columns as actual times. Since they aren’t recognized as time I am unable to sort the document based on the desired earliest departure time.

I have tried using the “Text to Column” function but for some reason that doesn’t seem to be working for me.

I’ve attached a copy of the Excel doc that I’m using. If someone wouldn’t mind taking a look and letting me know how to solve the problem I would greatly appreciate it!

NV Travel.xlsx (11.1 KB)

Hi @tmcwade12

Use Format Cells activity

Regards,

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.