Keep the formula cells highlighted, and right click to show context menu and select Format Cells. Select a blank cell which you want to output the converted result, and enter this formula =A2/24, drag fill handle over the cells you need. Here are some simple formulas which can help you to quickly convert decimal hours or decimal minutes to hh:mm:ss.ġ. In this article, I introduce some tricks for you to quickly finish this conversion in Excel.Ĭonvert decimal hours/minutes to time format with formulasĬonvert time to decimal hours/minutes/seconds In some cases, you may record time as decimal hours or minutes such as this 31.23, how can you convert this decimal hours or decimal minutes to standard time format hh:mm:ss as below screenshot shown. How to convert decimal hours/minutes to time format in Excel?
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |