=hour formula

[Karen]

I have summed up the total time, e.g 34:40. Needed to split this into 2 cells
for hours and minutes.

I used the =minute formula which worked fine but the =hour formula only
showed 10hrs.

How function can I use to show 34hrs?

 

[Teethless mama]

=INT(A1*24)

 

[Jacob Skaria]

With Total time in A1 try the below..

=VALUE(TEXT(A1,"[h]"))

If this post helps click Yes

 

[Karen]

Thank you Jacob, this solved my problems.

With Total time in A1 try the below..

=VALUE(TEXT(A1,"[h]"))

If this post helps click Yes
---------------
Jacob Skaria

I have summed up the total time, e.g 34:40. Needed to split this into 2 cells
for hours and minutes.

I used the =minute formula which worked fine but the =hour formula only
showed 10hrs.

How function can I use to show 34hrs?