Hi guys,
I have the numerical value 3.67 and I would like to change it into minutes and seconds.
So I would like 3.67 to display as "3:40" (3 minutes and 40 seconds).
Or 4.5 would display as "4:30" (4 minutes and 30 seconds).
Is there a way to do this? I've fiddled with the custom formatting but I can't get it work.
m:ss is just giving me a zero value. I don't need to convert values higher than 5 or lower than 1.
Thanks,
Dave.
Bookmarks