Better to divide by 86400, or by 24 and 60 and 60, rather than multiplying
by 0.00001157407407 which is an approximation.
--
David Biddulph

"FSt1" wrote in message
...
hi again.
clicked the wrong button on the last post. sorry.
excel keeps time as a percent of a day.
12 hours = .5 day
1 hour = 0.041666667 day or =1/24
1 minute = 0.000694444 day or =1/24/60
1 second = 0.00001157407407 day or =1/24/60/60

unless your 229.92 seconds are a decimal value of a day, you will have to
do
some math.
multiply 229.92 by 0.00001157407407.
format as time. about 3 minutes 50 seconds.(00:03:50)

regards
FSt1

"Mark" wrote:

I have a value of 224.92 seconds that I want to 'convert' to mm:ss (or
hh:mm:ss if the number is large enough)