Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculate Time in Word Tables
I have a simple table with time in (B1) and time out (B2). All I want is in
B4 the difference between b1 and b2 to show the total time worked. Is there any way to calculate time in a Word table? I have tried embedding an Excel spreadsheet but it does not give me the create date as the time in. I have created a button for that but keep getting the 'Method "Range" of object "_Global" failed' message. I'm at my wits end. |
#2
|
|||
|
|||
Hi kaykayIT,
You could use a macro with the DateDiff function, or field coding. The macro approach is fairly straightforward and is well-enough documented in Word's vba help file. Apart from the complexity of coding a field, the main issue you'd have is that you'd have to use bookmarks to hold the times (though you could use CREATEDATE explicitly) because Word's table cell referencing doesn't work with date or time values. For a 'tutorial' with examples of how you can do this using Word fields, download the Word document at: http://www.wopr.com/cgi-bin/w3t/show...?Number=249902 (url all one line) Cheers "kaykayIT" wrote in message ... I have a simple table with time in (B1) and time out (B2). All I want is in B4 the difference between b1 and b2 to show the total time worked. Is there any way to calculate time in a Word table? I have tried embedding an Excel spreadsheet but it does not give me the create date as the time in. I have created a button for that but keep getting the 'Method "Range" of object "_Global" failed' message. I'm at my wits end. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.799 / Virus Database: 543 - Release Date: 19/11/2004 |
#3
|
|||
|
|||
This link doesn't seem to work
Quote:
|
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I divide a page into three sections? | Microsoft Word Help | |||
WordPerfect - copying formatting | Page Layout | |||
Continuous breaks convert to next page breaks | Microsoft Word Help | |||
macro in word | Microsoft Word Help | |||
Is there a way to "join" tables in Word 2003? | Tables |