Convert Decimal to Hours & Mins

[swaink]

Hi All

I have browsed for the answer to this one and found a few answers that point me in the right direction but they don't quite fit what I need.

I need to convert the data from a text value to HH:MM

I have been given an extract of some 40k lines in one column I have the time of an event showing as 0.013 instead of 00:13 another may be 0.125 which would be 01:25.

Would anyone be able to offer any suggestions as to how I can best convert these values

Regards

Kevin

 

[fairwinds]

Hi,

Try:

=--REPLACE(SUBSTITUTE(B2,".",""),3,0,":")

in an adjascent column. Format cell as time.

 

[Lewiy]

Perhaps:

=--SUBSTITUTE((A1*10),".",":")

 

[swaink]

Lewiy/Fairwinds

Thats fantastic and has done the job

Many thanks for your help its appreciated

Regards

Kevin