Time to Number Convertion help.

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

AxonFantaxon

New Member
Joined
Sep 3, 2019
Messages
5
Assuming your data is in A1, use this;

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

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
5,319
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
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,099,082
Messages
5,466,534
Members
406,484
Latest member
kaksolver

This Week's Hot Topics

Top