[Year 12 IT Apps] Off Topic Excel Question

[Diane Peat]

Aha! We tried the mm.ss.0 formatting but didn't do the first part - Shizuko
will be SO impressed with me tomorrow when I give her the ideas that have
arrived tonight!

Thanks so much for this and especially the quick response.

Diane Peat
Firbank Grammar School
BRIGHTON
dpeat at firbank.vic.edu.au




-----Original Message-----
From: itapps-bounces at edulists.com.au
[mailto:itapps-bounces at edulists.com.au]On Behalf Of Mike Brookes
Sent: Tuesday, 29 May 2007 11:22 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: Re: [Year 12 IT Apps] Off Topic Excel Question

Hi Dianne
Excel stores dates and times as decimal numbers of days. To convert
seconds to days divide by 86400 then use a custom format of mm.ss.0 to
display the result in mins and secs with one dec place

Mike Brookes
Chief cook and bottle washer
Copperfield College

Diane Peat wrote:
> Hello everyone
>
> I have a totally off-topic question that I'm hoping someone can answer.
> One of our teachers has a spreadsheet with figures for LOTE exercises
> entered in seconds (eg. 122.45, 80.32, 98.45, etc). she wants to
> reformat these figures into minutes but the result displays in minutes
> with decimals in .10 increments (eg. 10:48) which, as well as being
> frustrating, is incorrect! Does anyone know how to reformat minutes so
> that they display in minutes, seconds and tenths of seconds?
>
>
>
> Any ideas would be most appreciated.
>
>
>
> Thanks
>
> Diane Peat
>
> Firbank Grammar School
>
> BRIGHTON
>
> dpeat at firbank.vic.edu.au <mailto:dpeat at firbank.vic.edu.au>
_______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
IT Applications Mailing List kindly supported by
http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority
and
http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers
Association Inc