Time Value problem

[AFZAL SOHAIL]

Hello Dear Team,
I have time value data I want to write this is as under:-
Thanks a lot in advance.

TIME VALUE	EXPECTED RESULTS
2 hr. 57 min.	2:57
3 hr. 10 min.	3:10
2 hr. 40 min.	2:40
2 hr. 18 min.	2:18
3 hr. 04 min.	3:04
3 hr. 58 min.	3:58
11 hr. 50 min.	11:50
1 hr. 39 min.	1:39
2 hr. 00 min.	2:00
12 hr. 04 min.	12:04
5 hr. 46 min.	5:46
3 hr. 22 min.	3:22
4 hr. 31 min.	4:31
3 hr. 56 min.	3:56
3 hr. 27 min.	3:27

 

[Phuoc]

Try this:

Book1
	A	B
1	IME VALUE	EXPECTED RESULTS
2	2 hr. 57 min.	2:57
3	3 hr. 10 min.	3:10
4	2 hr. 40 min.	2:40
5	2 hr. 18 min.	2:18
6	3 hr. 04 min.	3:04
7	3 hr. 58 min.	3:58
8	11 hr. 50 min.	11:50
9	1 hr. 39 min.	1:39
10	2 hr. 00 min.	2:00
11	12 hr. 04 min.	12:04
12	5 hr. 46 min.	5:46
13	3 hr. 22 min.	3:22
14	4 hr. 31 min.	4:31
15	3 hr. 56 min.	3:56
16	3 hr. 27 min.	3:27
Sheet1

Cell Formulas
Range	Formula
B2:B16	B2	=--SUBSTITUTE(SUBSTITUTE(A2,"hr.",":"),"min.","")

 

[AFZAL SOHAIL]

Thanks a lot for quick response,
I am waiting for more response, after that I will be mark as solution.

 

[smozgur]

Thanks a lot for quick response,
I am waiting for more response, after that I will be mark as solution.

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.