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.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac