One way

=INT(A1*24)

assuming the 25:28 is in A1

Regards,

Peo Sjoblom


"Steven" wrote in message
...
I am calculating overtime and have a time of 25:28. That is 25 hours and
28
minutes. It is formatted Custom [h]:mm so you actually see the 25:28 in
the
cell. I want to pull the hours into a sererate cell as 25 in this case.
I
keep getting a 1 and if I try to add this hour and another number it gives
me
another confusing answer.

My question is how do I return the hours (25 in this case) to its own cell
and have it actually be a value of 25.

Thank you for your help.

Steven