Base 60 in ExcelXP

  Desert Andy 13:37 23 Mar 04
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 04

Format the cell using a custom format:

[h]:mm

  Desert Andy 16:57 23 Mar 04

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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

The updated 'Corel Painter inside Photoshop' plugin ParticleShop offers new brushes

New MacBook Pro 2017 release date, UK price and tech specs: Kaby Lake MacBook Pro to launch in…