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/

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/