Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time question
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time question
Must be a format error on my part then. Maybe date and
time: I clicked C10 then FormatCellsNumberTime, chose the second option (13:30:55). Entered the formula into C10, then typed 10.48 into C10. As a result, 11:31:12 is displayed in the cell and 10/01/1900 11/31/12 shows in the formula bar. Regards. "Bob Phillips" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time question
11:13:12 is stored as .48 (.48 * 24 = 11.52 hours)
the 10 is interpreted as 10 January 1900. So you aren't converting your value as you claim. -- Regards, Tom Ogilvy "Stuart" wrote in message ... Must be a format error on my part then. Maybe date and time: I clicked C10 then FormatCellsNumberTime, chose the second option (13:30:55). Entered the formula into C10, then typed 10.48 into C10. As a result, 11:31:12 is displayed in the cell and 10/01/1900 11/31/12 shows in the formula bar. Regards. "Bob Phillips" wrote in message ... 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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time question
Best I can get is:
=TEXT((C10)/24/60/60, "[h]:mm:ss") Regards. "Tom Ogilvy" wrote in message ... 11:13:12 is stored as .48 (.48 * 24 = 11.52 hours) the 10 is interpreted as 10 January 1900. So you aren't converting your value as you claim. -- Regards, Tom Ogilvy "Stuart" wrote in message ... Must be a format error on my part then. Maybe date and time: I clicked C10 then FormatCellsNumberTime, chose the second option (13:30:55). Entered the formula into C10, then typed 10.48 into C10. As a result, 11:31:12 is displayed in the cell and 10/01/1900 11/31/12 shows in the formula bar. Regards. "Bob Phillips" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |