I'm having trouble converting a decimal to time of day.
I'm calculating time off a number of seconds lapsed, and the number may be very large (on the scale of 17 years having passed).

This: =(MOD((B26/86400),1)*24)
...meaning, =(MOD((CELL_CONTAINING_SECONDS_LAPSED/60*60*24),1)*24) ...
gives me stuff like 6.99844, which is great. It tells me it's almost 7:00 am. But...is there a way to format it to time that doesn't give me ##### or 12:00 every single time?
Oh, and I don't want to occupy any other cells...