Convert decimal to feet and inches

[chunu]

Hi,
how can i convert decimal to feet and inches

Calculation9.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1	Total feet	40
2	qty	feet	inch	total ft	b.feet	Balance ft	Balance inch
3	1	2	6	2.50	38	37	6
4	1	3	4	3.33	34	34	2
5
6
7	I want to enter feet and inches like below not in separate column like above how can I get result same as above.
8
9	Total feet	40
10	qty	feet	inch	total ft	b.feet	Balance ft	Balance inch
11	1	2.6		2.60	37	37	4.8
12	1	3.4		3.40	34	34	0
Sheet1

Cell Formulas
Range	Formula
D11:D12,D3:D4	D3	=SUM(B3*12+C3)*A3/12
E3,E11	E3	=IF(D3=0, 0, $B$1-D3)
F3,F11	F3	=ROUNDDOWN(IF(D3=0, 0, $B$1-D3),0)
G11:G12,G3:G4	G3	=IFERROR(MID(E3,FIND(".",E3,1),LEN(E3))*12,0)
E4,E12	E4	=IF(D4=0, 0, $B$1-D4-D3)
F4,F12	F4	=ROUNDDOWN(IF(D4=0, 0, $B$1-D4-D3),0)

 

[Fluff]

You cannot enter 2ft 6in as 2.6, otherwise what would 2.1 be? 2ft 10in, or 2ft 1in.
If you enter it as 2.06 you can use

+Fluff 1.xlsm
	B	C
3	2.06	2.5
4	3.04	3.333333
5	2.11	2.916667
Main

Cell Formulas
Range	Formula
C3:C5	C3	=DOLLARDE(B3,12)

 

[chunu]

You cannot enter 2ft 6in as 2.6, otherwise what would 2.1 be? 2ft 10in, or 2ft 1in.
If you enter it as 2.06 you can use

+Fluff 1.xlsm
	B	C
3	2.06	2.5
4	3.04	3.333333
5	2.11	2.916667
Main

Cell Formulas
Range	Formula
C3:C5	C3	=DOLLARDE(B3,12)

Thanks a lot

 

[Fluff]

You're welcome & thanks for the feedback.