Please help to get the value

P

pol

In a cell (a1..10) have the vllue as follows in hrs)

41.30
50.15
60.45

I want to change as

41.50
50.25
60.75

Please advice me to change the minitus portion of the time

With thansk and regards

Polachan
 
D

David Biddulph

It would have been better to put the numbers in using correct Excel time
formatting, so 41:30 not 41.30, but if they have been put in wrongly, they
can be corrected by
=INT(A1)+MOD(A1,1)*100/60
 
D

David Biddulph

Doesn't that give the wrong number of hours if the number of seconds is 50
or more?
Wouldn't INT() be better than ROUND(,) ?
 
J

Jacob Skaria

Oops.. You are right. Thanks David

--
Jacob


David Biddulph said:
Doesn't that give the wrong number of hours if the number of seconds is 50
or more?
Wouldn't INT() be better than ROUND(,) ?
--
David Biddulph





.
Click to expand...
 
Top