Time formulas

[Guest]

(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?

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Pete_UK]

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

 

[Guest]

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.

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

(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?

 

[Guest]

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.

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

(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?

 

[Bob I]

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.

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.

:

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

(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?

 

[Peo Sjoblom]

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

 

[David Biddulph]

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

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.

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

(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?

 

[Bob I]

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?!?!?!?