Base 60 in ExcelXP

  Desert Andy 13:37 23 Mar 2004
Locked

Hi All

I'm trying to add up the amount of time I've spent in different classes at school. I want to add up the columns in time, (hours and minutes), however, as soon as i got to 24 hours ( the 24 hour clock), my addition goes back to zero. Anyway I can add up the columns in base 60 as opposed to base 10 ?

Appreciate it if anyone has an answer.

Many thanks

Andy

  VoG II 14:18 23 Mar 2004

Format the cell using a custom format:

[h]:mm

  Desert Andy 16:57 23 Mar 2004

VoG

Thanks very much, you have solved my problem, if only I could have asked you 5 hours earlier!!

Andy

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

Halloween Photoshop & Illustrator tutorials: 20 step-by-step guides to creating spook-tacular…

iPhone X news: Release date, price, new features & specs

Comment créer, modifier et réinitialiser un compte Apple ?