Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-05-2016, 01:53 AM
macropod's Avatar
macropod macropod is offline Add Time Code Windows 7 64bit Add Time Code Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,513
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by ossosso View Post
While writing I want to add at the beginning of each line a time code similar to that [HH:MM:SS:FF], so a text example could be:



[00:15:30:00] The Solar System formed 4.6 billion years ago from the gravitational collapse of a giant interstellar molecular cloud.
[00:15:45:22] The vast majority of the system's mass is in the Sun,
[00:15:53:12] with most of the remaining mass contained in Jupiter.
A macro to insert a time and paragraph break is fairly straightforward, but what does the FF represent? Your examples don't seem to relate to the time elapsed, since the difference between 00:15:30 and 00:15:45 is 45 seconds, not the 22 in the output, though the difference between 00:15:45 and 00:15:53 is 12 seconds, which your last example reflects. If it's meant to be seconds, what happens if there are more than 60?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Add Time Code a code to add altering time to cells tesoke Excel Programming 3 12-17-2015 12:31 PM
To me the code on the youtube tutorial looks the same as mine but a I get a run-time chrisd2000 Excel Programming 1 07-02-2014 11:23 AM
Time allotted minus time used with result in hour and minute esther6086 Excel 2 04-29-2014 05:03 PM
Add Time Code Vba macro code for grouping the data based on 2 hours time dharani suresh Excel Programming 5 04-29-2014 03:25 AM
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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:12 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