Converting time to Minutes
Converting 5:08:00 using =(HOUR(D2) *60)+MINUTE(D2) works perfect.
That turns out 308 minutes.
However, converting 119:38:00 the same way doesn't work. As a matter
of fact, HOUR(XN) where the value of the cell XN = 119:38:00 returns
23. It should be 119.
How can I convert 119:38:00 to 7178 minutes?
|