How can I convert time h:min to decimal hrs?

Hi Gary,

I apologize for the inconvenience, I don't have an answer to that question.

I pulled the information from this article(http://answers.microsoft.com/thread/76e2b875-bd9e-4df2-be29-8bdc70733d39), Richard shows the solution to the problem.

Alternatively, you can use the below formula if you don't understand the explanation of the former formula.

=HOUR(A1)+MINUTE(A1)/60+SECOND(A1)/3600.

Please note the cell where you enter this formula must have the cell format “Number” with two decimals.

Please let me know if I can help with anything else. I will be glad to answer any other questions that you might have

Warm Regards, Utkarsh

Thanks for your response.

I do not understand the value you get when you enter A1*24. Why that formula and how do you get the value shown??

Then later you format cells to get the decimal hours. I don't understand how that returns the decimal hours.

They do seem correct but as I've indicated I can't follow how the above steps ( formulas) give the results they do.

Any explanation would be appreciated.

Thanks, Gary

Hi GNCENGR,

Thank you for reaching out to this forum. I'm Utkarsh and as a fellow Microsoft user, I'm here and ready to help you today.

I am a user like you, this is a user forum and not Microsoft directly.

Here's how to convert time from h:min to decimal hours in Excel:

1. In Excel, you can use some formulas to convert [hh:mm:ss] to decimal hours:

a. Select a cell and type the formula =A1*24 into it and press Enter to get the result out, if you need, drag fill handle over range to apply the formula.

b. Right click at the selected range and click Format Cells from context menu. And in the popping dialog, select Number from the Category list, and specify the decimal places you need.

c. Click OK. Now each time has been converted to decimal hour at once.

Here is reference link below:

https://www.extendoffice.com/documents/excel/2772-convert-time-to-hours-minutes-seconds.html

Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.'

2. if first not work try to use the following formula: =HOUR(A1) * 24 + MINUTE(A1)

Replace A1 with the cell reference containing the time you want to convert. This formula will give you the decimal value of the time in hours and minutes.

I am NOT a Microsoft Agent/Employee.

I hope this is helpful! Best Regards, Utkarsh