Text to time

[Gusch]

I know I have fixed this in the past, but I can't remember how I did it. This should be any easy one for you guys:

I have a report that gives me a time in text format (7:15 am). I need to do some calculations from the time and I'm struggling with converting into something I can work with.

Thanks for the help.

 

[T. Valko]

thx timevalue worked.

You're welcome. Thanks for the feedback!