Hi Charles here,
Convert the time in to number like 96:47 , I want to convert as 96 or 97 (
numeric value)
Hi Charles here,
Convert the time in to number like 96:47 , I want to convert as 96 or 97 (
numeric value)
If you still want to keep the "Time" format, you can go to Format|Cells and choose Custom from the list, then type [h].
or if you want the number format, use: =ROUND(A1*24,0) and format as number, where A1 contains the original time.
Multiply with 24 and use ROUND or INT
=ROUND(A1*24,0)
=INT(A1*24)
where A1 holds 96:47
--
Regards,
Peo Sjoblom
"Charles" <[email protected]> wrote in message
news:[email protected]...
> Hi Charles here,
>
> Convert the time in to number like 96:47 , I want to convert as 96 or 97 (
> numeric value)
Thanks, it works.
"Peo Sjoblom" wrote:
> Multiply with 24 and use ROUND or INT
>
> =ROUND(A1*24,0)
>
> =INT(A1*24)
>
> where A1 holds 96:47
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
>
> "Charles" <[email protected]> wrote in message
> news:[email protected]...
> > Hi Charles here,
> >
> > Convert the time in to number like 96:47 , I want to convert as 96 or 97 (
> > numeric value)
>
>
>
Thanks, It works
"Vito" wrote:
>
> If you still want to keep the "Time" format, you can go to Format|Cells
> and choose Custom from the list, then type [h].
>
> or if you want the number format, use: =ROUND(A1*24,0) and format as
> number, where A1 contains the original time.
>
>
> --
> Vito
> ------------------------------------------------------------------------
> Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
> View this thread: http://www.excelforum.com/showthread...hreadid=489414
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks