| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Elapsed time format in Word table?
One of my vendors wants me to use a Word document to submit my time. (I would
typically submeit an Excel Invoice, but that's not what he wants.) In Excel I can format a cell as a time (using the extended time format), enter a time in hh:mm (PM of AM). by having two such cells, I can calculate the elapsed time by subtracting the first from the second. I could probably do the same thing by writing a macro in VBA (time consuming), but I'd prefer it if the cells could be formatted by clicking on something, and the formula could be entered directly to the cell. Has anyone done this? Thanks, Mike Burke -- "The mind is quicker than you think!" |
|
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
|
Elapsed time format in Word table?
Hi Mike,
To see how to do this and just about everything else you might want to do with dates and times in Word, check out my Date Calc 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=249902 or http://www.gmayor.com/downloads.htm#Third_party In particular, look at the items titled 'Add Or Subtract Two Time Periods' and 'Date and Time Calculations in a Table'. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Mike Burke" wrote in message ... One of my vendors wants me to use a Word document to submit my time. (I would typically submeit an Excel Invoice, but that's not what he wants.) In Excel I can format a cell as a time (using the extended time format), enter a time in hh:mm (PM of AM). by having two such cells, I can calculate the elapsed time by subtracting the first from the second. I could probably do the same thing by writing a macro in VBA (time consuming), but I'd prefer it if the cells could be formatted by clicking on something, and the formula could be entered directly to the cell. Has anyone done this? Thanks, Mike Burke -- "The mind is quicker than you think!" |
|
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
|
Elapsed time format in Word table?
OK, that was an awesome response. Thank you!
Mike -- "The mind is quicker than you think!" "macropod" wrote: Hi Mike, To see how to do this and just about everything else you might want to do with dates and times in Word, check out my Date Calc 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=249902 or http://www.gmayor.com/downloads.htm#Third_party In particular, look at the items titled 'Add Or Subtract Two Time Periods' and 'Date and Time Calculations in a Table'. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Mike Burke" wrote in message ... One of my vendors wants me to use a Word document to submit my time. (I would typically submeit an Excel Invoice, but that's not what he wants.) In Excel I can format a cell as a time (using the extended time format), enter a time in hh:mm (PM of AM). by having two such cells, I can calculate the elapsed time by subtracting the first from the second. I could probably do the same thing by writing a macro in VBA (time consuming), but I'd prefer it if the cells could be formatted by clicking on something, and the formula could be entered directly to the cell. Has anyone done this? Thanks, Mike Burke -- "The mind is quicker than you think!" |
|
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
|
Elapsed time format in Word table?
Hi Mike,
While you can do this in Word - as my 'tutorial' shows - or use a macro, I'd much rather do it in Excel - you can always embed an Excel worksheet in your Word document. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Mike Burke" wrote in message ... OK, that was an awesome response. Thank you! Mike -- "The mind is quicker than you think!" "macropod" wrote: Hi Mike, To see how to do this and just about everything else you might want to do with dates and times in Word, check out my Date Calc 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=249902 or http://www.gmayor.com/downloads.htm#Third_party In particular, look at the items titled 'Add Or Subtract Two Time Periods' and 'Date and Time Calculations in a Table'. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Mike Burke" wrote in message ... One of my vendors wants me to use a Word document to submit my time. (I would typically submeit an Excel Invoice, but that's not what he wants.) In Excel I can format a cell as a time (using the extended time format), enter a time in hh:mm (PM of AM). by having two such cells, I can calculate the elapsed time by subtracting the first from the second. I could probably do the same thing by writing a macro in VBA (time consuming), but I'd prefer it if the cells could be formatted by clicking on something, and the formula could be entered directly to the cell. Has anyone done this? Thanks, Mike Burke -- "The mind is quicker than you think!" |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Truncating time format in Word merged document | Mailmerge | |||
| Macro to calculate and insert number of elapsed years? | Microsoft Word Help | |||
| Formula for number of days elapsed? | Tables | |||
| Format Date and Time to show Military Time | Microsoft Word Help | |||
| Working With Elapsed Time In Word Table Fields | Tables | |||
Linear Mode
