Word Table formulas for adding time

At http://www.gmayor.com/downloads.htm#Third_party you'll find a link to download DateCalc.zip, a tutorial on date/time field formulas in Word for almost anything you can think of. It's the work of fellow MVP Paul Edstein (a.k.a. macropod).

You can start with the example in "Date and Time Calculations in a Table", about halfway through the document. Applying the same principle to time calculations isn't simple but can be done.

If the end time of the previous row is bookmarked as "prev", the first column could contain the field

{ QUOTE { ask d "Duration in hours:minutes" { d } } }

and the second column, the start time (assumed to be the same as the previous row's end time), would be

{ QUOTE { prev } }

Then the third column, the end time of the current row, could be calculated as

{ QUOTE { SET ph{ = { prev \@ H } } } { SET pm{ = { prev \@m } } } { SET dh{ = { d \@ H } } } { SET dm{ = { d \@ m } } } { SET eh{ = ph + dh + INT((pm + dm)/60) } } { SET em{ = pm + dm } } { IF em > 60 { set em{ = em - 60 } } } "{ eh }:{ em }" }

The hard part is that Word allows only one bookmark with a given name per document. You'd need some macro support to convert the result to plain text (unlink the fields) and then recreate the prev bookmark and put the fields into the next empty row.

It would probably be a lot easier to use Excel or an Excel Spreadsheet in a Word document.

Formula in B3 is =C2

Copy the formula in C2 and B3 down as many rows as necessary and then just enter the Duration of each activity and everything falls into place.