Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop
Topic starter
Right folks I've got this in cell A1 [b]30.10.2011 22:53[/b] (10:53pm on 30th October 2011). I need to convert from that into the excel time/date format number, so that I can subsequently use the Excel date and time formatting options. Can anyone give me a formula to do it?
I'd like to put the answer in B2
Ta
and why oh why would a company specify a format that uses commas as the decimal seperater and then use CSV the text file type 🙄
Posted : 03/11/2011 10:47 am
format custom dd/mm/yyyy hh:mm
😀
Posted : 03/11/2011 10:52 am
Plenty of options.
Will using find & replace (ctrl H) and replacing the '.' with a / work?
Posted : 03/11/2011 10:52 am
Topic starter
Will using find & replace (ctrl H) and replacing the '.' with a / work?
Genius! Ta
Posted : 03/11/2011 10:58 am