Time Conversion

**monty78** · 02-09-2009, 01:08 AM

HI,

I'm importing times into excel that are in the current format :

1.25.73
(as an example this would mean 1 minute, 25 seconds, 73 one hundrenths of a second).

Does anyone know how if excel can convert this to seconds so it would read :

85.73

I have tried to format the cells but I don't think excel can recognise a time with two decimal points ???

Any help would be appreciated.

Thanks.

Chris Bode · 02-09-2009, 01:27 AM

Well, you can use some mathematics to derive the result as predicted
Suppose that you have the data 1.25.73 in A4 then select any other cell and write following formula
=CONCATENATE(MID(A4,1,FIND(".",A4)-1)*60+MID(A4,FIND(".",A4,2)+1,2),".",MID(A4,FIND(".",A4,2)+1,2))

Hope this works for you…

Have a nice time

Chris

**monty78** · 02-09-2009, 02:33 AM

Many thanks Chris...works great !!

**JBeaucaire** · 02-09-2009, 03:18 AM

If the time you noted is in cell E1, this does it, too:

=(E1-INT(E1))*86400

EDIT: I just noticed the non-standard time format. This formula works off Excel's normal time format of 00:01:25.73