How do convert time into numeric
 

Hi Charles here,

Convert the time in to number like 96:47 , I want to convert as 96 or 97 (
numeric value)

How do convert time into numeric
 

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

How do convert time into numeric
 

Multiply with 24 and use ROUND or INT

=ROUND(A1*24,0)

=INT(A1*24)

where A1 holds 96:47


--

Regards,

Peo Sjoblom


"Charles" wrote in message
...
Hi Charles here,

Convert the time in to number like 96:47 , I want to convert as 96 or 97 (
numeric value)

How do convert time into numeric
 

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" wrote in message
...
Hi Charles here,

Convert the time in to number like 96:47 , I want to convert as 96 or 97 (
numeric value)

How do convert time into numeric
 

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