Time Calculation

[Guest]

What is the secret to adding-up time? I have my cells set for [h]:mm and
when I sum the column the total of wrong. What am I missing?
Thanks!

 

[Guest]

Could be a case of data inconsistency,
ie some of the times are "text" times ..

Instead of using eg: =SUM(A2:A5)
Try a gentle coercion via SUMPRODUCT, viz.:
=SUMPRODUCT(--(A2:A5))

with the formula cell custom formatted as: [h]:mm

 

[David Biddulph]

What you are missing is enough information for contributors to the group to
be able to help you.

We are not clairvoyant, despite the impression given by some fellow
contributors. If you merely say "it's wrong", we're not likely to be able
to guess where you have made the mistakes in your formulae. If you tell us
what numbers you are trying to add up, and what answers you are getting,
then we may be able to help.

 

[Guest]

An expample: In one column: 8:38 + 12:58 with a Sum of 21:36. Paychex gets a
total of 20:96.
Thanks

What you are missing is enough information for contributors to the group to
be able to help you.

We are not clairvoyant, despite the impression given by some fellow
contributors. If you merely say "it's wrong", we're not likely to be able
to guess where you have made the mistakes in your formulae. If you tell us
what numbers you are trying to add up, and what answers you are getting,
then we may be able to help.
--
David Biddulph

What is the secret to adding-up time? I have my cells set for [h]:mm and
when I sum the column the total of wrong. What am I missing?
Thanks!

 

[David Biddulph]

8:38 + 12:58 *does* add up to 21:36.
I don't know what "Paychex" is, but you might want to tell them that there
are 60 minutes in an hour.
--
David Biddulph

An expample: In one column: 8:38 + 12:58 with a Sum of 21:36. Paychex
gets a
total of 20:96.
Thanks

What you are missing is enough information for contributors to the group
to
be able to help you.

We are not clairvoyant, despite the impression given by some fellow
contributors. If you merely say "it's wrong", we're not likely to be
able
to guess where you have made the mistakes in your formulae. If you tell
us
what numbers you are trying to add up, and what answers you are getting,
then we may be able to help.
--
David Biddulph

What is the secret to adding-up time? I have my cells set for [h]:mm
and
when I sum the column the total of wrong. What am I missing?
Thanks!

 

[Guest]

How are you calculating it? If you do it on a calculator as 8.38+ 12.58, it
= 20.96. Paychex is a Payroll Service.

8:38 + 12:58 *does* add up to 21:36.
I don't know what "Paychex" is, but you might want to tell them that there
are 60 minutes in an hour.
--
David Biddulph

An expample: In one column: 8:38 + 12:58 with a Sum of 21:36. Paychex
gets a
total of 20:96.
Thanks

What you are missing is enough information for contributors to the group
to
be able to help you.

We are not clairvoyant, despite the impression given by some fellow
contributors. If you merely say "it's wrong", we're not likely to be
able
to guess where you have made the mistakes in your formulae. If you tell
us
what numbers you are trying to add up, and what answers you are getting,
then we may be able to help.
--
David Biddulph
What is the secret to adding-up time? I have my cells set for [h]:mm
and
when I sum the column the total of wrong. What am I missing?
Thanks!

 

[David Biddulph]

8:38 is 8 hours and 38 minutes
12:58 is 12 hours and 58 minutes
As I said before, there are 60 minutes in an hour, so if you add those two
durations together you get 21 hours and 36 minutes.

As for the numbers you are putting into your calculator:
8.38 is 8 and 38 hundredths, not 8 and 38 sixtieths
12.58 is 12 and 58 hundredths, not 12 and 58 sixtieths
As you have asked the calculator a different question, it is not surprising
that it has given a different answer.

You need to be careful of the difference between times (with a colon as the
separator between hours and minutes) and numbers with a decimal point.

You will also need to be careful if you use the result of Excel's time
calculation in further calculations and you are looking for numbers of
hours, as Excel's times are actually numbers of days.
--
David Biddulph

How are you calculating it? If you do it on a calculator as 8.38+ 12.58,
it
= 20.96. Paychex is a Payroll Service.

8:38 + 12:58 *does* add up to 21:36.
I don't know what "Paychex" is, but you might want to tell them that
there
are 60 minutes in an hour.

An expample: In one column: 8:38 + 12:58 with a Sum of 21:36. Paychex
gets a
total of 20:96.
Thanks
:

What you are missing is enough information for contributors to the
group
to
be able to help you.

We are not clairvoyant, despite the impression given by some fellow
contributors. If you merely say "it's wrong", we're not likely to be
able
to guess where you have made the mistakes in your formulae. If you
tell
us
what numbers you are trying to add up, and what answers you are
getting,
then we may be able to help.
What is the secret to adding-up time? I have my cells set for
[h]:mm
and
when I sum the column the total of wrong. What am I missing?
Thanks!