Hairy decimal to time of day?

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...

If you didn't multiply by 24 in your formula and formatted the fraction as time I think you'll be right.

Just tried it. Gave me all #######.

The ###### normally means the column width is too short to display. Have you widened the column to see if that fixes the problem?

Bwahahaha!!!

You guys are awesome.

Thanks!

Glad to help