| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
