time question

[teiben]

I'm stuck & I suspect it's something stupid but...I have a db w/duration field, which will never be greater than 1 hour, so I want to set it as date/time, but i want it to accept time only values: i.e 35:40 w/seconds - I tried date/time and picked the short time format, which I thought would do it , but when I enter 33:20 I get an error, yet I can enter 23:42

 

[Brianwarnock]

Assuming that is 33 minutes then 00:33:20 should be fine.

Brian