Time tallying

  • Thread starter Thread starter Andy Cowley
  • Start date Start date
A

Andy Cowley

Hi, I've been given a task to tally a lot of call times for our support
desk. They are eneterd in the format : hh:mm:ss and the data type is set to:
[hh]:mm:ss According to everything I could find on the Net about it this
should work when just doing a simple =SUM() function. Lets say for example
my data is in H1 through H24. I would to add this up use the following
=SUM(H1:H24) This however gives me the total 00:00:00. The data type for
the total box is also set the same as the data boxes. It does work however
if I add them up with =SUM(H1+H2...H24) However with six months of calls to
do for 11 different users broken down by week this isn't really practicable.

Any help greatly appreciated.

ANDY

PS: EXCEL 2000
 
I suspect your "times" were entered as text, which SUM() ignores (but
the + operator doesn't - it will try to coerce the operands to numbers).

Try this:

Select your column. Choose Data/Text to Columns and click Finish in the
Text to Columns dialog. This will coerce text "times" to real times.
 
Thanks very much that works perfectly now


JE McGimpsey said:
I suspect your "times" were entered as text, which SUM() ignores (but
the + operator doesn't - it will try to coerce the operands to numbers).

Try this:

Select your column. Choose Data/Text to Columns and click Finish in the
Text to Columns dialog. This will coerce text "times" to real times.




Andy Cowley said:
Hi, I've been given a task to tally a lot of call times for our support
desk. They are eneterd in the format : hh:mm:ss and the data type is set to:
[hh]:mm:ss According to everything I could find on the Net about it this
should work when just doing a simple =SUM() function. Lets say for example
my data is in H1 through H24. I would to add this up use the following
=SUM(H1:H24) This however gives me the total 00:00:00. The data type for
the total box is also set the same as the data boxes. It does work however
if I add them up with =SUM(H1+H2...H24) However with six months of calls to
do for 11 different users broken down by week this isn't really practicable.

Any help greatly appreciated.

ANDY

PS: EXCEL 2000
Click to expand...
Click to expand...
 
Back
Top