How would I show a cell that's currently in decimal minutes in HH:MM:SS format:
For example: displaying 15.50 as 5:30.
I tried:
=FORMAT(A1, "HH:MM:SS")
but am getting a #NAME? return
I've played with cell formatting but haven't cracked it yet.
Thanks for any help.
For example: displaying 15.50 as 5:30.
I tried:
=FORMAT(A1, "HH:MM:SS")
but am getting a #NAME? return
I've played with cell formatting but haven't cracked it yet.
Thanks for any help.