In some worksheets, a cell formatted hh:mm with a value of 24 will yield the
desired result - 24:00 (24 hours). As of today some worksheets are yielding
00:00 for the same value of 24, and in the formula bar, you can see that the
24 has been converted to 1/24/1900 12:00:00AM - the 24th day of the century.
How can this be corrected so that it will show 24 hours.