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 |