Need UDF to return time format from string input

[Andrew_Harris]

I have a lot of login logout data that that displays time as, for example, "1:37:22PM" as a string. I'm trying to make a UDF that inputs time in that format (I've attached a workbook with a small sample dump of the times) and outputs the correct time format so that I can use comparison operators. Unfortunately, I seem to be incredibly bad at parsing this and keep messing up. Any tips or help would be incredibly appreciated,

Thanks!

testbook.xlsx

Edit: Apparently, I also am bad at attachements.

[jindon]

try this

Please Login or Register  to view this content.

[Andrew_Harris]

Thank you so much! I had no idea the CDate() function existed. Remarkably helpful.