Suppose a cell contains decimal number expressing a timespan in minutes. How do I display that value in traditional HH:MM:SS format?
For instance, I have 75 in a cell, and I want it displayed as 1:15:00 (i.e. 60 +15)
I tried playing around with the time formats, but I cannot get it right. Indeed, the HH:MM of 75 is 55:58. Not really sure what time display expects as a value.
I can do all the computations myself of course, but I was hoping there would be a quicker way.