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
--
David Biddulph

"pol" wrote in message
...
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