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.

Tips on how to use Microsoft 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.