Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-31-2017, 07:29 AM
StephenRay StephenRay is offline Calculate document completion time Windows 7 64bit Calculate document completion time Office 2010 64bit
Advanced Beginner
Calculate document completion time
 
Join Date: Jan 2012
Location: Overland Park, Kansas
Posts: 53
StephenRay is on a distinguished road
Default

Macropod, I have worked with your code:
MsgBox Format(ActiveDocument.BuiltInDocumentProperties("T otal Editing Time") / 1440, "[d] hh:mm")



It gives about the same number of minutes and seconds.
It seems to start as soon as you open a new document. The clock starts ticking as soon as you open a new document.
I am convinced it is accurate too.

However, with my work, I open a new document and may not start on a piece of work for several minutes or may an hour later. I am having so much fun with the ease of my work using macros and I marvel at the time savings; so I get everything ready to go ahead of time. Everything is set up before I start on a piece of work. I have to balance accuracy and speed, but the speed part is thrilling. Without Macros, one piece of work takes around 30 minutes of fast, intense work. With Macros my fastest time is 8 minutes and 19 seconds! Of course some of these pieces of work require telephone calls and other research to clarify the data; and this research may greatly increase the time.

And I have it rigged so that when I get a piece of work and start to work on it, the very first thing that happens is that I copy and paste an identifying Number using a macro that also grabs the Now time That's when the time starts.

Nevertheless, if I didn't already have the other code with lots of logic and code already set up I know I would use your code.

I have never studied Microsoft Word very much, I learned enough just to be able to write a document with some shapes and arrows. So I am surprised that anything exists such as your (ActiveDocument.BuiltInDocumentProperties("Total Editing Time") / 1440, "[d] hh:mm")

But I did recently buy a good book "Word 2016 IN DEPTH" by Faithe Wempen, a QUE Book. I bought it to compliment my studies of VBA. On page 39-43 Document Properties are discussed, including the Statistics Tab.

This is all very interesting. I must look this over to see if I might ever want to use anymore of these.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate time over two dates Diver Excel 3 07-22-2017 11:31 PM
Calculate document completion time how to calculate average time aymanharake Excel 6 02-17-2017 04:22 PM
Calculate Time in Hours and Percent pabyford Excel 6 12-13-2016 12:29 PM
Calculate document completion time Formula To Calculate Countdown Days To Project Completion Catherine Project 1 02-19-2014 11:15 AM
Calculate document completion time How to get cells to calculate time? jrasche2003@yahoo.com Excel 2 02-09-2007 07:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:31 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft