Please help to get the value
working fine thanks a lot
"Jacob Skaria" wrote:
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
|