Hour function

[vmjan02]

I have the in column A as time values and in column B i am using the hour function to get the hour from column A, but in some cases I am getting incorrect hour values

Ref the table below. (It is some samples) Any idea as how to get the correct values.

AHT	Hrs
6:03:05	6
1:47:05	1
47:15:16	23	It has to be 47​
1:48:48	1
3:01:22	3
1:50:24	1
2:12:14	2
25:19:16	1	It has to be 25​
1:46:56	1
46:59:24	22	It has to be 22​
1:49:24	1
30:08:42	6	It has to be 30​

 

[jasonb75]

The result is correct for the HOUR() funciton, 47:15:16 is 1 day, 23 hours, 15 minutes, 16 seconds.

To get the results that you want, try =INT(A2*24)

 

[MARK858]

Why does 46:59:24 have to be 22 when 30:08:42 has to be 30?

 

[vmjan02]

yes, 46:59:24 need to be 46 as it is the total Hrs involved to solve the case. and same is with 30:08:42

 

[MARK858]

Then the formula jasonb75 posted should work for you.

 

[vmjan02]

=INT(A2*24)

Yes, Perfect it wokrd fine. thanks