How to Convert Time to Decimal Values in Excel?

Was this post useful to you?

What is the formula to convert time to decimal values in Microsoft Excel 2010?

Alex's picture
Alex
Mon, 09/24/2012 - 14:10

1 Answers for "How to Convert Time to Decimal Values in Excel?"

You can extract the hour and minute numbers from the time using HOUR and MINUTE formulas.

=HOUR(A2)+(minute(a2)/60)

Post your reply

Filtered HTML

  • Allowed HTML tags: <b> <br> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.