| Home |
| Search |
| Today's Posts |
|
#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/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ctrl+V pasting to multiple non-adjacent cells | Excel Discussion (Misc queries) | |||
| How do I center data across multiple cells in excel without mergi. | Excel Discussion (Misc queries) | |||
| split combined Time Date cells | Excel Discussion (Misc queries) | |||
| How do I extract cells from multiple workbooks | Excel Discussion (Misc queries) | |||
| Counting "rows", i.e. simultaneous criteria for multiple cells | Excel Worksheet Functions | |||
Linear Mode
