I have a field in my table that stores time...it is formatted for Short Time. The issue...this field shows how long it takes to do a task. Sometimes it takes over 24 hours. The field errors out if I enter more than 23:59. I would like the field to stay formatted to HH:MM but I need to exceed 24 hours.
Can anyone help?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.