I have imported time data that populates a cell as :35 which represents 35 secs. I applied a formula =(0&B3)+0 ....but that converts the time into 0:35:00 (which means 35 minutes, not seconds)
How can I convert :35 into 0:00:35???