Give the sum/difference cell a custom format of:

[hh]:mm:ss



Django Cat wrote:

While I'm here...

I have never been able to get Excel to calculate time totals instead
of treating time values as times of day.

I'm currently keeping a time sheet; I enter the time I start and the
time I finish working in two columns, and then subtract start from end
in a third column to give the time for that session. This column is
then totalled to give the total time spent on the project so far.

However (and I bet this has come up in this group a million times
before & everyone know what's coming next) every time my total accrued
hours goes over 24 it reverts to 00:00 just like a clock would.

All cells are formated as hh:mm, and times are entered as, for
example, 16:28.

Any suggestions gratefully recieved.
DC

--

Dave Peterson