If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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/ |
#2
|
|||
|
|||
I don't know what TIMECODE is but if you have a numeric time value that Excel
sees as time you can put =8/86600 in an empty cell press enter, copy the cell, select the timevalues and do editpaste special and select add, reformat as time again (it will be decimal values when you do this so you need to format it as time again) Or you can use a help column and =A1+TIME(,,8) Regards, Peo Sjoblom "timroutledge" wrote: 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 | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Calendar Question | Josh | General Discussion | 7 | March 28th, 2005 11:19 PM |
Scheduling in multiple time zones | [email protected] | Calendar | 1 | February 19th, 2005 05:31 PM |
Adding text suffix to formula in multiple cells. | joenjoe | New Users | 2 | September 12th, 2004 02:57 PM |
How to Change the Color of multiple cells when multiple cells returns text of "x" | Felipe | Worksheet Functions | 0 | November 6th, 2003 09:16 PM |