View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 620
Default Time Calculation

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

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


"David Biddulph" wrote:

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


"Sam" wrote in message
...
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!