Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Time question | Excel Worksheet Functions | |||
Time Question | Excel Worksheet Functions | |||
Time Question | Excel Discussion (Misc queries) | |||
Time question | Excel Discussion (Misc queries) | |||
Time Question | Excel Discussion (Misc queries) |