Re: Convert co-ordinates to/from decimal

In article <1h4xv1u.1gk1ch619qxkxeN%me9@xxxxxxxxxxx>, Bella Jones
<me9@xxxxxxxxxxx> wrote:

> Elliott Roper <nospam@xxxxxxxxx> wrote:
>
> > In article <1h4v1of.l7d4x2m1hitdN%me9@xxxxxxxxxxx>, Bella Jones
> > <me9@xxxxxxxxxxx> wrote:
> >
> > > Elliott Roper <nospam@xxxxxxxxx> wrote:
> [adding times]
>
> > > > Have you got Excel?
> > > >
> > > > select a column for your numbers
> > > > format->cells->number->time and choose the one like 37:30:55
> > > >
> > > > That's it. enter your hh:mm:ss. You can then add 'em up with the
> > > > equivalent of SUM(R[-10]C:R[-1]C) and the answer will be in the right
> > > > format already.
> > >
> > > Oooh, hon, this is beyond me, but thanks for the suggestion.
> >
> > Oops. It is hard to describe with the right amount of detail. It is
> > incredibly easy.
> > "set the number format to hours minutes seconds and do what comes
> > naturally" is a less threatening looking recipe for the same thing.
>
> Heh. Still Greek to me though, but I may try later, as an exercise.

Elliot seems to be using the 'other'[1] way of labelling cells. My way
of writing that would be SUM(A1:A25), or even highlighting the column
you want to add and clicking on the 'sum' symbol, which writes it in
for you.

1. Other to me, that is. And perhaps you too.

--
Sara
.

Relevant Pages

  • Re: Its Here
    ... Keep the old one so if your computer needs service, you can reinstall it and Dell ... will never know (Oops! ... Tom, that is an excellent suggestion, but I decided to just go with a new ... UPS with a sine wave output. ...
    (alt.sys.pc-clone.dell)
  • Re: A trip on the wayback machine...
    ... have sworn that it was Garibaldi making the exact same suggestion in the search ... Oops. ... Yeah, me too. ... God, do you remember the fine toothed comb we went ...
    (rec.arts.sf.tv.babylon5.moderated)
  • Re: How to create a command button like Show/Hide Edit Mark button?
    ... Oops. ... do remember seeing a suggestion that some tricky VBA might be able to ... Prev by Date: ...
    (microsoft.public.word.customization.menustoolbars)
  • Re: Can Vista be "locked down" ?
    ... Oops! ... You're advocating again. ... Shame on you! ... It was a suggestion. ...
    (microsoft.public.windows.vista.general)
  • Re: Happy Birthday for the Peachy Ashie Passion Girlie
    ... yes - I definitely said "Oops" ... 'K - you need to clean your lenses, hon' ...
    (rec.humor)