Works fine for me. Sure you formatted it as time, not date or date and
time?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Stuart" wrote in message
...
Not strictly the correct group, but I wonder if someone
would be kind enough to help with this:

As a result of a calculation, the value in C10 is 10.48
This represents 'seconds'. I need to convert this to
hh:mm:ss format.

If I format the cell as a Time and then place in the formula bar:

=ROUND(C10, 2)/24/60/60 should I not get the time
00:00:10 ?

It seems to lose the formula and show as a date.

Regards.