[Doug Robbins - Word MVP]

Assuming that you are entering the times as minutes (15, 30, 45 etc.) into
the cells of a column in a table, in the cell where you want the total to
appear, you can used the formula

{ = SUM(ABOVE)/60 }

If you are using .15 for 15 minutes, then you would use

{ = SUM(ABOVE)/.6

However, using 1.5 for one hour and 30 minutes, will not give you the
correct result. You would have to use .90 for that; two hours would be 1.2
etc.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"computerkiller" wrote in message
...
I am going to input them as 15 min intervals. I do not know what you mean
as
format, unless you mean time = .15. I guess that would be ordinary text. I
am
not using FormFields. This is just as a column with the time in it. (Note
this is in Word.)

Thank you for responding. DB.

_______________

"Doug Robbins - Word MVP" wrote:

How are the times being entered into the invoice? In what format? As
ordinary text? Into FormFields?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"computerkiller" wrote in
message
...
I have created an invoice to record the minutes I work on a job but can
not
figure out how to sum the total time I want the minutes in the format
hours
and half hours, ie 1.5 hours. Can some one tell me how to do this.
Thank
you.