Thread: Time question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stuart[_21_] Stuart[_21_] is offline
external usenet poster
 
Posts: 154
Default 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.