Time formulas
 

(EXCEL 2003)
Cells [A1:A4300] I have time values of phone calls in hours, min, sec.
Example:

0:11:34
1:04:45
....


if i use =SUM(A1:A4300) I get an output of: 146:09:49 I then want to take
the number of days that the person worked (110) during this data set to find
an average time per day on the phone.

I don't think I am getting the correct output:

Suggestions?

Time formulas
 

I get:

1:19:44

what output do you get?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"dj479794" wrote in message
...
(EXCEL 2003)
Cells [A1:A4300] I have time values of phone calls in hours, min, sec.
Example:

0:11:34
1:04:45
...


if i use =SUM(A1:A4300) I get an output of: 146:09:49 I then want to take
the number of days that the person worked (110) during this data set to
find
an average time per day on the phone.

I don't think I am getting the correct output:

Suggestions?

Time formulas
 

Slight flaw in your approach? Presumably this is a list of calls that
your company is charged for (i.e. outgoing calls) but your workers
will also receive incoming calls, and therefore spend longer on the
phone ...

If you divide this total by the number of working days and format the
cell in Excel time format then you should get 1:19:44 - the formula is
=A1/110, where A1 contains 146:09:49.

Hope this helps.

Pete

On Sep 25, 8:28 pm, dj479794
wrote:
(EXCEL 2003)
Cells [A1:A4300] I have time values of phone calls in hours, min, sec.
Example:

0:11:34
1:04:45
...

if i use =SUM(A1:A4300) I get an output of: 146:09:49 I then want to take
the number of days that the person worked (110) during this data set to find
an average time per day on the phone.

I don't think I am getting the correct output:

Suggestions?

Time formulas
 

I got that too, just using =146:09:49/110. I am just not confident in the
value. So it is saying one hour 19 min and 44 seconds per day. I was looking
at the help files and it said if the sum adds up to more than 24 hours to
multiply by 24. That confused me. I need to make sure that this output is
correct, because all executives at my company are going to see these values
and make hire/fire decisions based on it.

"Sandy Mann" wrote:

I get:

1:19:44

what output do you get?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"dj479794" wrote in message
...
(EXCEL 2003)
Cells [A1:A4300] I have time values of phone calls in hours, min, sec.
Example:

0:11:34
1:04:45
...


if i use =SUM(A1:A4300) I get an output of: 146:09:49 I then want to take
the number of days that the person worked (110) during this data set to
find
an average time per day on the phone.

I don't think I am getting the correct output:

Suggestions?

Time formulas
 

Thank you. We did consider incoming calls as well for it is an account
management position. we removed all personal calls. thanks for confirming
that value is correct.

"Pete_UK" wrote:

Slight flaw in your approach? Presumably this is a list of calls that
your company is charged for (i.e. outgoing calls) but your workers
will also receive incoming calls, and therefore spend longer on the
phone ...

If you divide this total by the number of working days and format the
cell in Excel time format then you should get 1:19:44 - the formula is
=A1/110, where A1 contains 146:09:49.

Hope this helps.

Pete

On Sep 25, 8:28 pm, dj479794
wrote:
(EXCEL 2003)
Cells [A1:A4300] I have time values of phone calls in hours, min, sec.
Example:

0:11:34
1:04:45
...

if i use =SUM(A1:A4300) I get an output of: 146:09:49 I then want to take
the number of days that the person worked (110) during this data set to find
an average time per day on the phone.

I don't think I am getting the correct output:

Suggestions?

Time formulas
 

take a piece of paper, divide 146 by 110, does the result appear to
approximately match the answer that excel gave? the problem with
learning math with a calculator, is the student doesn't learn math only
to use a calculator, and doesn't know if they made a mistake.

dj479794 wrote:
I got that too, just using =146:09:49/110. I am just not confident in the
value. So it is saying one hour 19 min and 44 seconds per day. I was looking
at the help files and it said if the sum adds up to more than 24 hours to
multiply by 24. That confused me. I need to make sure that this output is
correct, because all executives at my company are going to see these values
and make hire/fire decisions based on it.

"Sandy Mann" wrote:


I get:

1:19:44

what output do you get?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"dj479794" wrote in message
...

(EXCEL 2003)
Cells [A1:A4300] I have time values of phone calls in hours, min, sec.
Example:

0:11:34
1:04:45
...


if i use =SUM(A1:A4300) I get an output of: 146:09:49 I then want to take
the number of days that the person worked (110) during this data set to
find
an average time per day on the phone.

I don't think I am getting the correct output:

Suggestions?

Time formulas
 

Remember when you could buy something for 8.35 and you could give the
cashier a 10 plus 0.35 in change and you immediately got 2 back. Nowadays
they have to look at the register and get rather bewildered


--


Regards,


Peo Sjoblom



"Bob I" wrote in message
...
take a piece of paper, divide 146 by 110, does the result appear to
approximately match the answer that excel gave? the problem with learning
math with a calculator, is the student doesn't learn math only to use a
calculator, and doesn't know if they made a mistake.

Time formulas
 

146:09:49 divided by 110 gives you the 1:19:44 if the cell is formatted as
time.

The multiplication by 24 is if you want it converting from Excel time
(stored as a number of days) to decimal hours (& in that case you'll format
as Number or General). That gives 1.32876 hours, which is of course the
same as 1:19:44.
--
David Biddulph

"dj479794" wrote in message
...
I got that too, just using =146:09:49/110. I am just not confident in the
value. So it is saying one hour 19 min and 44 seconds per day. I was
looking
at the help files and it said if the sum adds up to more than 24 hours to
multiply by 24. That confused me. I need to make sure that this output is
correct, because all executives at my company are going to see these
values
and make hire/fire decisions based on it.

"Sandy Mann" wrote:

I get:

1:19:44

what output do you get?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"dj479794" wrote in message
...
(EXCEL 2003)
Cells [A1:A4300] I have time values of phone calls in hours, min, sec.
Example:

0:11:34
1:04:45
...


if i use =SUM(A1:A4300) I get an output of: 146:09:49 I then want to
take
the number of days that the person worked (110) during this data set to
find
an average time per day on the phone.

I don't think I am getting the correct output:

Suggestions?

Time formulas
 

Yes, the other day at a local store, one of the automatic change
machines at the cash register quit, so they closed the lane down, seems
no one there could count back change. And they say the SAT Math scores
are increasing?!?!?!?

Peo Sjoblom wrote:

Remember when you could buy something for 8.35 and you could give the
cashier a 10 plus 0.35 in change and you immediately got 2 back. Nowadays
they have to look at the register and get rather bewildered