How to sum in base 60

[Joshua Cossette]

I am tracking how much time is spent doing different tasks
in the course of a day, five days a week. My days are in
columns and the tasks are in rows. I need to total the
time spent on each task over the five days in the week.
My time values are HH:MM. How do I get it to sum the row
counting in base 60? Thank you very much anyone who can
help!

 

[Frank Isaacs]

I'm not sure why you'd want to use base 60; I would think you just want a
total of hours and minutes. You could try a custom number format for the
cell(s) with the sum:

[h]:mm

or

[hh]:mm
--
HTH -

-Frank
Microsoft Excel MVP
Dolphin Technology Corp.
http://vbapro.com