nance1432m
New Member
- Joined
- Aug 7, 2019
- Messages
- 2
Hi, I am working with a spreadsheet that was pulled from an external data source. It imported the time column as text (example: 07:30m or 12:00am). No space between. I've gotten it to work if I break it into 2 separate columns using the following 2 formulas: =TIMEVALUE(SUBSTITUTE(D2,"pm"," pm")) and =TIMEVALUE(SUBSTITUTE(D2,"am"," am")). Can anyone help so that it's one formula in one column? Please 
