To expand - I would like to do this when the number is the result of a MAX
formula. I have tried using the custom mm:ss format but this just gives me
the result 00:00 for some reason.
XL stores times as fractional days, so if you want a true XL time,
you'll need to divide by 24*60*60:
A1: 23
A2: =A1/86400 ===> 0:00:23
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.