Please help to get the value
 

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

Please help to get the value
 

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

Please help to get the value
 

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

Please help to get the value
 

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


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

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

Please help to get the value
 

Oops.. You are right. Thanks David

--
Jacob


"David Biddulph" wrote:

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


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


.