Converting decimal values in to seconds [ss]

[hechesspee]

Hi,
I'm looking to convert the below data with decimals in to seconds.
Column-->Data-->Desired format
A1-->0.3 --> 30
A2-->0.03 --> 03
A3-->1.3 --> 90
A4-->40.3 --> 2430

I used formula =A1/864 and used format [ss] and it gave me the correct result when the value is less than 1 i.e up to 0.59
When it is above 1 for example 1.3, it is converting into 130, not 90.

Can someone please advise me on how to get the right value?

Thanks
HSP

 

[etaf]

Are the numbers entered just number - not time
and
the output is a number for seconds and NOT a time function

=(INT(A1)*60)+(A1-TRUNC(A1))*100

will give seconds in number format

then
=((INT(A1)*60)+(A1-TRUNC(A1))*100)/86400
format the cells in [SS]

Book1
	A	B	C	D	E	F	G
1	A1-->0.3 --> 30			0.3	0	30	30
2	A2-->0.03 --> 03			0.03	0	3	03
3	A3-->1.3 --> 90			1.3	1	90	90
4	A4-->40.3 --> 2430			40.3	40	2430	2430
Sheet1

Cell Formulas
Range	Formula
E1:E4	E1	=INT(D1)
F1:F4	F1	=(INT(D1)*60)+(D1-TRUNC(D1))*100
G1:G4	G1	=F1/86400

 

[Fluff]

Another option if you want a number & not time
=DOLLARDE(A1,60)*60

 

[hechesspee]

Thank you @etaf and @Fluff , both solutions work. Reduced a lot of my effort!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Phuoc]

Another way:

=A1*60+MOD(A1,1)*40

 

[hechesspee]

Another way:

=A1*60+MOD(A1,1)*40

Thank you @Phuoc , this works too.