Time to Number Convertion help.

[PrinceExcel]

How to convert 13:10 (13 hrs. 10 mins) into 13.7 (number)?

 

[PrinceExcel]

*13:10 to 13.10

 

[AxonFantaxon]

Assuming your data is in A1, use this;

=CONCATENATE(LEFT(TEXT(A1,"hh:mm"),2)," Hours ",RIGHT(TEXT(A1,"hh:mm"),2)," Minutes")

 

[sandy666]

with correction from post#2
maybe: =SUBSTITUTE(TEXT(A1,"hh:mm"),":",".")
if you want a number : =--SUBSTITUTE(TEXT(A1,"hh:mm"),":",".") and set two decimals

 

[sandy666]

or even: =--TEXT(A1,"hh.mm") with two decimals