February 1st in Formulas by Excelbud .
Convert Decimals to Time
Easily convert decimals to time in Excel.
Let’s Begin
Ever need to quicky convert decimals to time in Excel? Well, now you can!
A user of this site sent us an email asking how to convert decimals on a timesheet to actual time. The easiest way is to use the formula below.
=A1/(24*60)
Cell B2 will now display a decimal.
We now need to format Cell B2 to display time. To make this happen, right click the cell and click “Format Cells”
Once open, go down to the “Custom” category. In the “Type” field, enter “hh:mm:ss” and click OK!
Were done!
That’s pretty simple Excel tip, but it does come in handy. If anyone is having any difficulty, simply use the comment box below.
