Time question
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.
|