Avatar

Level 4

Hi radzmar,

I am trying to make what I thought was going to be a simple task timing form but I cant seem to get the formats or total calulation to work.

I created a simple table that adds a row when the user clicks a button. I used your sample script for the total field, but I want to make it easier for the user for the start/end times.

I added the function $=Num2Time(Time()) to the click event of the start and stop cells. This works ok in adding in a time to each cell when the user clicks but it wont display the seconds no matter what I try.

The issue is I cant seem to get the start/stop cells to show HH:MM:SS and the total cell always shows 1440.

If I go back to manually entering numbers, the total works fine.

Any suggestions on how to correct my click event so it works with the total script?