Please help to get the value

  • Thread starter Thread starter pol
  • Start date Start date
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
 
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
 
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(,) ?
 
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...
 
Back
Top