=hour formula
=INT(A1*24)
"Karen" wrote:
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?
|