[Simon Knight]

Hi,
I am attempting to write a script that uses three columns: Duration, Start and End. I wish to enter values for duration and Start (date) and have the enddate entered in the clumn "End". In order to make a start I need to read the value of the property "HoursPerDay". I have tried various syntax but I can not get it to work.

Script debugger offers the following:
tell column 3
tell properties
tell format
hoursPerDay
end tell
end tell
end tell

but if I attempt to add run this or a modified version with a set myVar to it always fails.
Any ideas?
best wishes
Simon