synchronizing timestamp feature with time on video software.

[999]

I am currently attempting to manage an establishment remotely using
video camera that I monitor over the internet. I need to record th
entrance and exit times of vehicles persons etc. the current way that
am doing this is way way too time consuming.

If I could link the timestamp feature in excel to the time recorded i
the video itself it would drastically reduce the time tiakes me t
monitor the business.


Let me give you an example of what i want to be able to do:

suppose it is 6:30 p.m and i am monitoring recorded video. someon
enters the establishment on the video at2:15 p.m. I use the timestam
feature in excel and it registers 2: 15 p.m ( the time on the video
INSTEAD of 6:30 p.m ( the time at which I am reviewing the video)

Furthermore, I want synchronization ( i.e if I review fifteen minute
of the video in 5 minutes, i want the timestamp feature to keep up wit
the fifteen minutes of " video" time, not the five minutes of " real
time)

How can I do this???


IS there anyway in which I can synchronize the time in excel
specifically the time stamp feature) with the time in the saved vide
recording INSTEAD of with the computer time??

Alternatively does anyone know of a way to manipulate the compute
clock to synchronize with the time in the video recording??

The video software is Panasonic's Network Camera Recorder

 

[paul]

what do you call the timestamp feature? is it ctrl: or similar
the only way i can think is some formulas.....ie you enter the currnet time
using the "timestamp"
You enter the video time in another cell
you have a button that you click when you want.Presumably you view on FF so
you know factors beween FF and real time.

 

[999]

timiestamp is the COntrol+ALT+ semicolon , ehich puts in the current
time ( from the computer clock) into the cell in excel in which you are
working in.

How would I determine the factor? sometimes I am reviewing thre video
footage at 5-7 times real speed, while at other moments I am ogin
slower than real life, so a constant factor probably would not work.

any thoughts ?

 

[999]

"i.e you enter the currnet time
using the "timestamp"
You enter the video time in another cell
you have a button that you click when you want.Presumably you view on
FF so
you know factors beween FF and real time.


Im already entering the viedo time manually. this si the time waster i
wan to avoid. I want excel to automatically enter the video time for me
when i do the " theimestamp" command, for which i need 3 fingers and 1
second, isntead of manually hunting for the time, for which wi would
take 3-4 seconds.

 

[999]

I can convert the film to mpeg format and play it in either windo
media player or windows moviemaker. can i synchronize the time of th
video in these software programs
with excel/lotus or any other alpanumeric program?