convert time to percentage

[phillipcook]

Hi All

so I know you can convert time to a percentage with the following:

A1 = 02:30

=hour(A1)+minute(A1)/60 which will return 2.5

My question is, how do you convert a time to a percentage that goes exceeds 24 hours?

for example if A1 = 158:30

???

Thanks in advance guys

 

[Tetra201]

Try

=A1*24 (formatted as General)