How to convert time format into decimals in Excel

Looking to convert data in time format into decimals on Excel?

Try this formula:
=A1*1,440/60
where A1 is a cell containing a time value

If A1= 12:35, it returns a value of 12.58.

This entry was posted in Functions. Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.

Post a Comment

Your email is never published nor shared. Required fields are marked *

You may use these HTML tags and attributes <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*
*