View Single Post
  #4   Report Post  
Cindy M -WordMVP-
 
Posts: n/a
Default

Hi ?B?YmlyZHdhdGNoZXI=?=,

Thanks for your reply. Actually, this question appears on a City and Guilds
Level 3 WORD PROCESSING exam, I can only think of one word processor (a very
old version of WordPerfect) that allows the addition of hours and minutes in
a table. The question specifically refers to a table created in the Word
Processor.The course book uses WORD 2000 (and 2003). I'll keep searching.
Anymore help would be most welcomed

I can't believe anyone would ask this. What's more, I can't believe I actually
figured it out sigh

1. you have to bookmark each time you're going to calculate with

2. You have to use a combination of =, If and Compare, with an IF field for
each and every possible time element. Since that's incredibly long, I'm only
going to show you the skeleton, it's up to you to write it all out...

{ = ({ IF { compare { Ref time1 } = "01:*" } = 1 "01" }{ IF { compare { Ref
time1 } = "02:*" } = 1 "02" }[continue here through 12]} - { IF { compare { Ref
time2 } = "01:*" } = 1 "01" }{ IF { compare { Ref time2 } = "02:*" } = 1 "02"
}[continue here through 12]}):[now do the same for time1 and time 2 from 00
through 59] \# "00" }

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)