Correct Time formula please

[tinferns]

In the below table time in HH:MM is not getting calculated properly. I am using formula Numerical Minutes/1440 and have converted the result in HH:MM format. What have I done wrong ? Please help... Thanks..

Book1
	A	B	C	D
1	No. of Items	AHT	Time Required	Time Required
2	85	5	425	07:05
3	150	5	750	12:30
4	1150	5	5750	23:50
5	360	5	1800	06:00
6	435	5	2175	12:15
7	3456	5	17280	00:00
Sheet1

Cell Formulas
Range	Formula
C2:C7	C2	=A2*B2
D2:D7	D2	=C2/1440

 

[etaf]

try using a format
[H]:mm
that will display hours above 24

Book4
	A	B	C	D
1	No. of Items	AHT	Time Required	Time Required
2	85	5	425	7:05
3	150	5	750	12:30
4	1150	5	5750	95:50
5	360	5	1800	30:00
6	435	5	2175	36:15
7	3456	5	17280	288:00
Sheet1

Cell Formulas
Range	Formula
C2:C7	C2	=A2*B2
D2:D7	D2	=C2/1440

 

[tinferns]

Thanks etaf.. that worked. Cheers..

 

[etaf]

you are welcome