Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-09-2015, 12:53 PM
hydrogyny hydrogyny is offline Time Stamps automatically changed to same time! Mac OS X Time Stamps automatically changed to same time! Office for Mac 2011
Novice
Time Stamps automatically changed to same time!
 
Join Date: Feb 2015
Posts: 2
hydrogyny is on a distinguished road
Default

So, basically you're saying (what i figured) is that there's no way to reference what all those previous times were, so those are gone for good? Sigh, oh well.



But from now on... using this Macro (thank you!) they should remain the same and not change?

Do you know why the Macro option would remain the same after closing / opening, but the way I was doing it before wouldn't? Just curious about the reasoning behind it... but as far as I can tell what you posted worked, so thanks a bunch!
Reply With Quote
  #2  
Old 02-09-2015, 08:57 PM
Charles Kenyon Charles Kenyon is offline Time Stamps automatically changed to same time! Windows 7 64bit Time Stamps automatically changed to same time! Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,582
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Quote:
Originally Posted by hydrogyny View Post

Do you know why the Macro option would remain the same after closing / opening, but the way I was doing it before wouldn't? Just curious about the reasoning behind it... but as far as I can tell what you posted worked, so thanks a bunch!
The method you were using was the insertion of a TIME field. This is really a variant of the DATE field which is good for showing the date or time that is NOW but not good for much else.
Using Date Fields in Microsoft Word
There are a number of fields that handle date and time. They can be very useful, but none would give you a time stamp that would stay unchanged when you insert a number of them at different times.

A TIME or DATE field can be locked so that it will not change, but this is an additional step. Such a field can still be unlocked, in which case it will lose its value. It can also be unlinked. That would change it to plain text.

The macro method is superior for your purposes.
Reply With Quote
Reply

Tags
time, timecodes, timestamps



Similar Threads
Thread Thread Starter Forum Replies Last Post
Time allotted minus time used with result in hour and minute esther6086 Excel 2 04-29-2014 05:03 PM
Time Stamps automatically changed to same time! I want Time to be automatically sequenced anienham Word 4 06-14-2012 04:08 PM
IE Object: Run-time problem (the link is not clicked in run-time but not in step-in tinfanide Excel Programming 1 03-04-2012 12:05 AM
Time stamps and postponing messages. thundermocos Outlook 0 10-29-2006 06:04 AM
Daylight Saving Time Changed all appointments nemeth Outlook 0 04-10-2006 01:33 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:36 AM.


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