Sum time values in a table

[Rick Vooys]

Hello,

I am trying to use a table to add up values, the only
problem is that the value being entered is a time value.
Like 4:56, for 4 hours 56 minutes. At the bottom I need
to have a total of the time? Right now I get an error, is
there any way to do this? Thanks ahead of time.

-Rick

[Greg]

Rick,

This was a challenge as I am clueless when it comes to VBA
which might be your best bet. Anyway I cobbled together a
method to add time in Word tables that I will shall with
you. First, be aware that for now this is limited to
hours and minutes. More work for you, not me :) would be
required to incorporate seconds or break hours into days.

First lets get the layout straigtened out. Rather than one
cell for a time entry, your will need three. One for the
hour, one for the (:) separator, and one for the minutes.
Use right justtify for the hours, a very narrow/minimum
margin cell for the :, and left justify for the minutes.

I assume that you are wantting to add a column of time
entries. In addition to the column of entries and the
final cell for the answer, this procedure will require two
addtitional cells. There could be a better way, but I
don't know it.

OK, if you have the formatting down proceed as follows:

For the purpose of illustration, Create a 3 column, five
row table as described above.

Enter the time separator ":" in Column B Rows 1-3 and 5.

Enter hours in Column A rows 1-3 and minutes in Column C
rows 1-3.

Enter the following formula in Cell A4:
{=Int(SUM (C1:C3)/60)}.
Enter the folowing formula in Cell C4:
{=SUM(C1:C3)/60 \##.####}
Enter the following formualt in Cell A5
{=SUM(A1:A4)}
Enter the following formala in Cell C5
{=(C4-A4)*60 \# "00" }

The curly brackets are entered with CTRL=F(
You can format cells A4 and C4 in white text to hide there
results.

As always, there may be a better way, but this will work.
>
>-Rick
>.
>

[Suzanne S. Barnhill]

When I do this in Excel, I use the following formulas:

For the hours: =SUM(D3:D36) + ROUNDDOWN((SUM(E3:E36))/60,0)
For the minutes: =MOD(SUM(E3:E36),60)

Where rows 3 and 36 are the ends of the sums. I don't believe Word has the
ROUNDDOWN function, which might make it more satisfactory to embed an Excel
sheet.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://www.mvps.org/word

"Greg" <hen...@hawaii.rr.com> wrote in message
news:02c101c2d140$c8da5860$d4f82ecf@TK2MSFTNGXA11...

[Greg Maxey]

Clever!! I think "cobbled" adequately described my method.

\\\\///////////
( @ @ )
----oo00---(_)---00oo----
Greg Maxey
A peer in "peer to peer" support
Ewa Beach, HI
"Suzanne S. Barnhill" <sbar...@mvps.org> wrote in message
news:eLv7EZW2...@TK2MSFTNGP11.phx.gbl...