How do convert time into numeric

C

Charles

Hi Charles here,

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

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
 
P

Peo Sjoblom

Multiply with 24 and use ROUND or INT

=ROUND(A1*24,0)

=INT(A1*24)

where A1 holds 96:47
 
Top