So, I have a form where I am saving an average length of time, which we enter manually from another source.
For ease of use for the people using the form, the length of time needs to be entered in a format like hh:mm:ss on the form, and then converted to seconds and saved as a long integer (I'm assuming this is how I would need to save it). So for example, the user enters 01:30:04 into the field. The value stored in the table would need to be 5404. Then, if the user views the record or needs to edit it, it will be displayed as 01:30:04.
I can get a field to display an integer in the hh:mm:ss format, but I'm at a loss as to how I would actually display it based on the field's 5404 value, for example, and actually save it to the table in the proper format.
Any ideas?
For ease of use for the people using the form, the length of time needs to be entered in a format like hh:mm:ss on the form, and then converted to seconds and saved as a long integer (I'm assuming this is how I would need to save it). So for example, the user enters 01:30:04 into the field. The value stored in the table would need to be 5404. Then, if the user views the record or needs to edit it, it will be displayed as 01:30:04.
I can get a field to display an integer in the hh:mm:ss format, but I'm at a loss as to how I would actually display it based on the field's 5404 value, for example, and actually save it to the table in the proper format.
Any ideas?