Total editing time

  • Thread starter @Homeonthecouch
  • Start date
@

@Homeonthecouch

Hello.
Is there a way of enabling the Total Editing Time that is displayed in the
properties?
Word does the time tracking but I can't find a way to enable it in excel.
I have searched google but found nothing.
Does anybody know if it is possible to enable it?
 
D

Dave Peterson

Excel doesn't keep track of this property.

@Homeonthecouch said:
Hello.
Is there a way of enabling the Total Editing Time that is displayed in the
properties?
Word does the time tracking but I can't find a way to enable it in excel.
I have searched google but found nothing.
Does anybody know if it is possible to enable it?

--
Any help is as always appreciated
Thank You

Andrew
 
D

Dana DeLouis

Is there a way of enabling the Total Editing Time that is displayed

Although Excel can't track editing time, here's an idea.
In Microsoft Outlook, one can track Office documents thru the Journal.
I believe the "Duration" field is the time the document was opened, which is
different than the time the document was edited.
Here's a technique from within the Journal. Have a View that Sorts by
Subject. Select all the entries for your document, and Copy (Ctrl+c). When
you paste into Excel, the pasted table will include the Heading Row. (ie
Subject, Start, Duration...etc)
Again, not ideal, but maybe a workaround.
 
@

@Homeonthecouch

Many thanks to the above for that information.

Andrew


Dana DeLouis said:
Although Excel can't track editing time, here's an idea.
In Microsoft Outlook, one can track Office documents thru the Journal.
I believe the "Duration" field is the time the document was opened, which
is different than the time the document was edited.
Here's a technique from within the Journal. Have a View that Sorts by
Subject. Select all the entries for your document, and Copy (Ctrl+c).
When you paste into Excel, the pasted table will include the Heading Row.
(ie Subject, Start, Duration...etc)
Again, not ideal, but maybe a workaround.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top