How do convert time into numeric

[Guest]

Hi Charles here,

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

 

[Vito]

If you still want to keep the "Time" format, you can go to Format|Cell
and choose Custom from the list, then type [h].

or if you want the number format, use: =ROUND(A1*24,0) and format a
number, where A1 contains the original time

 

[Peo Sjoblom]

Multiply with 24 and use ROUND or INT

=ROUND(A1*24,0)

=INT(A1*24)

where A1 holds 96:47

 

[Guest]

Thanks, it works.

Multiply with 24 and use ROUND or INT

=ROUND(A1*24,0)

=INT(A1*24)

where A1 holds 96:47


--

Regards,

Peo Sjoblom

 

[Guest]

Thanks, It works