![]() ![]() Using the Convert FunctionĪnother really easy (probably the easiest of the three methods), is to use the CONVERT function. The HOUR function simply returns the number of hours that have elapsed in the given time, and so does the MINUTE and SECOND function.īut since we need the final value in hours, we need to divide the minute value by 60 (to convert it into hours) and the second value by 60*60 (again to convert it into hours). Suppose, you have the times as shown below and you want to know how many hours have elapsed in the day.īelow is the formula to convert the time into hours =HOUR(A2)+MINUTE(A2)/60+SECOND(A2)/(60*60) If you don’t like the manual multiplication method, another really easy way to convert time to hours is by using the inbuilt time-related functions ( HOUR, MINUTE, and SECOND) Using Excel Functions (HOUR, MINUTE, and SECOND) INT only gives you the integer part and you don’t have to worry about any extra minutes. In case you only want the complete/full hour value and ignore the minutes part, use the below formula using INT. However, this wouldn’t change the value in the cell, which will continue to be 18.53 In case you haven’t, you may see the result as 19, as Excel shows you the rounded off integer value. Note: In case you get the hour value that has the decimals (such as 18.53), make you sure you have formatted it to show the decimals as well. In this example, the numeric value of 32 minutes in Excel would be 0.53 hours. In case you have a value such as 6:32 PM, using the above formula will give you the result as 18.53 (where the minutes/seconds part is shown in decimals and full/complete hours as integers). ![]() ![]() So, when you multiply it with 24, it gives you the number of hours that have passed. So while you see the value 6:00 PM, in the backend, it is stored as the value 0.75 (indicating that 18 hours out of the 24 hours have already passed). This means that each hour is stored as 1/24. A full day (24 hours) is stored as 1 in Excel. This works because of the fact that Excel stores dates and times as numbers. You can simply multiply it by 24 and it will give you how many hours have elapsed till that time. Suppose you have the time in a cell as 6:00 PM (in cell A2) and you want to convert it into hours. Using Simple Multiplication to Get the Hour Value In this section, I cover three different ways to convert time to hours in Excel. So let’s get started! Convert Time to Hours in Excel In the sections that follow, I will show you examples of how to convert Excel time to decimal values using these methods.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |