Base 60 in ExcelXP

  Desert Andy 13:37 23 Mar 04

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


  VoG II 14:18 23 Mar 04

Format the cell using a custom format:


  Desert Andy 16:57 23 Mar 04


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


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

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac