How to convert Hours Minute Second format number to decimal forma.

[Stefano]

My scientic calculator has two functios used to convert HMS format number to
decimal numbers in order to make calculations, I was looking for that
function in excel but it seem they havent include it. Does anyone knows if
there is an add in for this.
thank you

 

[Arvi Laanemets]

Hi

With time in A1:
=A1*24
to convert to hours;
=A1*(24*60)
to convert to minutes;
=A1*(24*60*60)
to convert to seconds.

(Format the cell with formula as General or Number)


Arvi Laanemets