Re: Convert "Time Interval" in "hours : minutes : seconds" to seco

Ragdyer, The problem I find with this method is that you can't then do
calculation on that cell. For example a time interval of 01:00:00 formatted
as [ss] give you 3600 but then in another cell if you try adding 1 to it you
get 1.04, instead of 3601.


J

"Ragdyer" wrote:

> If the time column is in "true" XL recognizable time format as you stated
> (hh:mm:ss), then all you have to do is format your total cell, or even each
> individual cell (if you choose) to the custom format:
> [ss]
> The square brackets prevent the seconds from rolling over into minutes, and
> then over into hours.
>
> You could also link your individual time cells to a separate column, and
> format that column to [ss], so that you might have a displayed comparison.
> --
> HTH,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "Ianukotnorth" <Ianukotnorth@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:1B66EA6B-D025-4BC0-9260-DD4BE56CFD80@xxxxxxxxxxxxxxxx
> > I wish to compare the cost of telephone calls between various telephone
> > service providers available to me.
> > I have downloaded a list of itemised call made by me from my present
> > provider and I wish to compare the cost of each call if I had used
> > alternative providers.
> >
> > I'm OK with the basic mathematical formulae - but I need to convert a
> "Call
> > Duration" in "hh:mm:ss" format to seconds.
> >
> > (I could use the "Text to columns" facility and then multiply the "
> Minutes
> > Column by 60 and the hours column by 360 - and add the three columns
> together
> > but feel this is clumsy when there must be a "nicer - easier way)
> >
> > Thanks for your help.
> >
> > Ian M
>
>
.

Relevant Pages

  • Re: Excel 07 - text displays as pound signs
    ... If I typed a number in that cell, ... surprised seeing the scientific format. ... Excel 07 - text displays as pound signs ... "Dave Peterson" wrote: ...
    (microsoft.public.excel.newusers)
  • Excel 07 - text displays as pound signs
    ... Excel 07 - text displays as pound signs ... "Dave Peterson" wrote: ... any given cell will suddenly appear as all pound signs. ... changed the format to a date. ...
    (microsoft.public.excel.newusers)
  • Re: Date and Time (entering in the format of mm/dd/yyyy and hh:mm:
    ... you can't format the difference to show mm ... Elapsed time is the difference between two times. ... In cell A1, ... On the Home tab, in the Cells group, click Format, and then click ...
    (microsoft.public.excel.misc)
  • Re: Completely baffled on what should be simple
    ... And remember just changing the format of the cell won't change the underlying ... sort, it didn't work. ... for the extensions that have either one or two 0's as the first numbers, ...
    (microsoft.public.excel.misc)
  • Re: Text formatted cells displaying numbers in scientific format
    ... When it 'sees' a large number it uses scientific format since ... I accept that Excel can't handle numbers greater than 15 digits and your ... string was 16 digits or more to be converted to a scientific value. ... It just doesn't display correctly in the cell (except after entering ...
    (microsoft.public.excel)
Loading