Just had to post an update to this old question:
I have been using the formula posted below for quite a while ...
It worked beautifully until I got a number formatted as 00:00. I played around with my data and discovered that this formula doesn't work when the seconds are > 59.5 or <60. It...