text time to hh:mm

  1. J

    Converting text time to HH:MM format

    I've got a data field that is represented in text format as XX hrs. XX mins. where the hours can be anywhere from 0 hrs to 120 hrs and the minutes from 1 min. to 59 min. I've tried using TIME(LEFT(a2,2),MID(a2,FIND("min",a2)-3,2),0) but if more than 24 hrs. it won't convert correctly. For...

Some videos you may like

This Week's Hot Topics