Covert text to time

[mobilizer]

How do you convert Cells with text

2 hours
2 hours
1 hour 15 minutes

to hh:mm ?

 

[Peter_SSs]

Welcome to the MrExcel board!

Is this what you mean? Formula copied down.

Excel Workbook
	A	B
1	2 hours	02:00
2	1 hour 15 minutes	01:15
3	20 Minutes	00:20
4	3 hours 1 minute	03:01
5	18 hours 58 minutes	18:58
6	1 hour	01:00
7	1 minute	00:01
8	10 hours 0 minutes	10:00
Text to Time

 

[dave3009]

You could use text to columns to split the data then use the new data to make your time

Excel Workbook
	A	B	C	D	E
1	2	hours			02:00:00
2	2	hours			02:00:00
3	1	hour	15	minutes	01:15:00
Sheet1

Excel 2007

Cell Formulas
Range	Formula
E1	=(TEXT(A1,"00")&":"&TEXT(C1,"00"))+0

 

[mobilizer]

Brilliant!! Thanks so much