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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top