[Django Cat]

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]

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

[Bob Phillips]

Format that cell as [h]:mm

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Django Cat" wrote in message
ps.com...
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

[Mike H]

If not a million times then its a great many. Format the subtraction cell as

[h]:mm

Mike

"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

[Django Cat]

On 25 May, 16:48, Mike H wrote:
If not a million times then its a great many. Format the subtraction cell as

[h]:mm


I thought it might have been! Thanks for all the prompt replies, I'll
give that formatting a try.

DC