[Year 12 IT Apps] Off Topic Excel Question

[jslynn at optusnet.com.au]

Hi Diane.

Try this in an Excel cell: type in the first figure of 122.45 (seconds). Divide by 60 to get 2.040833 (minutes). Format the cell to time using the 13:30:55 format. Divide by a further 24 to get this back to minutes.

This appears to alter the tenths of seconds - so it's not quite correct but it comes close to what your colleague needs. You might have to truncate the decimal fraction of the seconds then re-add them after the other operations but I haven't tried this.

I hope this helps.

Cheers,

Jeff Lynn,
Yeshivah and Beth Rivkah Colleges.


> Diane Peat <dpeat at firbank.vic.edu.au> 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>