Help me in time converting

[excel4u]

Hi

I have data in column A . two minutes fifty second like this 2.5 so on
i would like to change in second format 2.5 = 270 second

[DonkeyOte]

I'm confused ... by second format do you mean convert the seemingly non-number value to time & then to seconds ...

Incidentally I think the answer should be 170 seconds, no ?

return 170 as integer (not time format (decimal))

A1: 2.5
B1: =INT(A1)*60+(100*MOD(A1,1))
or
B1: =(INT(A1)+(MOD(A1,1)/0.6))*60

or time format (ie result is decimal - formatted to time)

A1: 2.5 (non time)
B1: =(INT(A1)+(MOD(A1,1)/0.6))/1440
B1 Formatted as: [ss]

[excel4u]

Thanxxxxxxxxxxxxxxxxx so much dear