Excel is great at doing standard time calculations using seconds, minutes, hours, days, months, and years. The problem is that on multiple occasions I have run into situations where I want the result in hours in excess of 24, rather than days and/or months.
For example engine run times are calculated in hours. Oil changes typically are at 50-hour intervals. Seeing this in days only confuses the issue.
Another example is MP3 playlist times. A total shown in hours is much more meaningful than one in days.
Is there a way, other than programming with VBA, to get a total in hours, suppressing the normal month and day calculations?