Form Field Calculation

[arroway]

I've been asked to create a locked Word03 .dot form which includes (amoungst other things) 3 feilds: a Time start field, a Time End field, and a Total Minutes field (showing the total minutes between the Start and End times). What's being asked is to allow the Start and End times to be user-entered and have the Total Minutes auto-populate on End-Time-Field-Exit and I'm not sure how to do this. Of course the user could fill in all three but that leaves too much room for errors, rounding, guestimations, mismatched formats, and the like on the users part. So I'm wondering if the Total Minutes would be another form field with a macro or would it be a VBA peice or maybe even using a formula and a StyleRef? I'm not sure if it's possible and if it is possible, what's the best practice. Can anyone apply their knowledge to this and come up with a gracefull solution?

Thanks in advance,
Dax

[HansV]

Word MVP (and Lounge member) macropod has written an extensive tutorial on date/time calculations in Word. It's not easy stuff, but it covers everything you'd ever want to do with dates and times in Word. You can download DateCalc.zip from Graham Mayor's download page.
The attached document shows how his field codes can be used to caclulate duration in minutes. To see how it works, unprotect the document (there's no password), and press Alt+F9 to view the field codes.

TimeCalc.doc

[arroway]

Cool! Thanks. That should get me well on my way. ~Dax