## Forum Discussion

# Time Conversion

Hi All,

I'm having trouble working out how to convert a time.

I have 1 minute 30.009 seconds in one cell, entered as 1:30.009 and want to display is another cell as 90.009 seconds. any help would be greatly appreciated

Ron

forbesy71 The simplest "formula" in C1 would be

**=A1**and than set the__custom format__for C1 to**[ss].000**Alternatively, you could use the TEXT function that allows you to type the desired format into the formula between quotation marks. Using a double hyphen (i.e. two minus signs) in front forces it to become a numeric value.

**= --TEXT(A1,"[ss].000")**

- Riny_van_EekelenPlatinum Contributor
- forbesy71Copper Contributor
Thanks for the reply, i have done that but i'm after the formula or steps to do it as below

- Riny_van_EekelenPlatinum Contributor
forbesy71 Sorry, but I don't understand what you mean by "

*I'm after the formula or steps to do it*".