Hi all I am getting this import out of a data base that formats the time as m/d/yy HH:MM AM/PM and I need to convert this to HH:MM AM/PM with no date attached linked to it . I have tried the following formula but it is not working on all cells (see Example below) any ideas on a formula or VBA to fix this issue
I have tried both =ABS(RIGHT(B5,7)) and =ABS(RIGHT(B5,8))
thanks in advance
I have tried both =ABS(RIGHT(B5,7)) and =ABS(RIGHT(B5,8))
thanks in advance
Moto IDP.xls | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Routing Set | Start Time | FC SL % | SL % | ||
2 | 12:00 AM | 11/29/05 12:00 AM | ||||
3 | ################## | 11/29/05 12:30 AM | ||||
4 | ################## | 11/29/05 1:00 AM | ||||
5 | 1:30 AM | 11/29/05 1:30 AM | ||||
MO-DS RawData |