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.

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" <[email protected]> wrote in message
news:[email protected]...
> 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.
>
>

Must be a format error on my part then. Maybe date and
time:
I clicked C10 then Format>Cells>Number>Time,
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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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.
>>
>>
>
>

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" <[email protected]> wrote in message
news:[email protected]...
> Must be a format error on my part then. Maybe date and
> time:
> I clicked C10 then Format>Cells>Number>Time,
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> >> 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.
> >>
> >>
> >
> >
>
>

Best I can get is:
=TEXT((C10)/24/60/60, "[h]:mm:ss")

Regards.

"Tom Ogilvy" <[email protected]> wrote in message
news:%23X%[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> Must be a format error on my part then. Maybe date and
>> time:
>> I clicked C10 then Format>Cells>Number>Time,
>> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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" <[email protected]> wrote in message
>> > news:[email protected]...
>> >> 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.
>> >>
>> >>
>> >
>> >
>>
>>
>
>