Try
=ROUND(A1,)+MOD(A1,1)/60*100

--
Jacob


"pol" wrote:

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