Hours Minutes Seconds Converted From Minutes

[nehpets12]

I have the formula to show Hours And minutes Could You Please Amend It To Show Seconds As Well

Thank You In Advance

Book2
	A	B	C	D
1	61.5	1Hours2Mins
Sheet1

 

[fairwinds]

hi,

Try:

=SUBSTITUTE(SUBSTITUTE(TEXT(A1/1440,"h:m:s"),":"," Hours ",1),":"," Mins ")&" Sec"

 

[erik.van.geit]

Hi,

I would go a completely different route
formula =A1/24/60 and format the cell as required

kind regards,
Erik

 

[nehpets12]

Thank You again very much for all your help