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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Decimal fractions to binary and vice versa 1
Access Convert a decimal time to hours and minutes 2
Converting Decimal Degrees to Degrees/Minutes/Seconds 1
Convert decimal days to hours and minutes 2
Need to convert Minutes:Seconds format to minutes with seconds con 2
Decimal to Time Format. 5
converting a decimal to time 3
Excel How To Convert Decimal To Inches 2

Back
Top