LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
timroutledge
 
Posts: n/a
Default Adding time to multiple cells using TIMECODE


Hi,

I have a spreadsheet with a custom field called TIMECODE that i have
downloaded. It basically means i can annotate what happens during a
video.
i.e

00:01:02 where the fields between : are hours, minutes, seconds

If I have a whole load of these in a column, how can i easily add
00:00:08 to each one... ie add 8 seconds to each cell....

Need help quickly!!!


--
timroutledge
------------------------------------------------------------------------
timroutledge's Profile: http://www.officehelp.in/member.php?userid=63
View this thread: http://www.officehelp.in/showthread.php?t=648363
Visit - http://www.officehelp.in | http://www.officehelp.in/index/index.php/

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Ctrl+V pasting to multiple non-adjacent cells Sam Excel Discussion (Misc queries) 1 March 21st 05 02:17 AM
How do I center data across multiple cells in excel without mergi. lmark Excel Discussion (Misc queries) 6 January 27th 05 05:55 PM
split combined Time Date cells Mark Ada Excel Discussion (Misc queries) 2 December 1st 04 03:06 AM
How do I extract cells from multiple workbooks Trevor Excel Discussion (Misc queries) 1 November 25th 04 10:59 PM
Counting "rows", i.e. simultaneous criteria for multiple cells gkline Excel Worksheet Functions 2 November 19th 04 07:30 AM


All times are GMT +1. The time now is 01:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"