- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
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?
Views
Replies
Total Likes