But the results are still unwieldy. The first result in your example is a datetime, the second is a numeric in seconds. If we have a time datatype these would be much simpler.

* add 3 hours and 30 minutes to 4pm to get 7:30pm
4pm + 3:30 = 7:30pm

* The difference (or lapsed time) between 7:30pm and 4pm is 3 hours and 30 mins
7:30pm - 4pm = 3:30


>? {, 17:30:32} + 400
>? {, 17:30:32} - {,5:22:57}
>
>
>>I requested a time datatype. My reasons:
>>- easy validation of well and poorly contructed time
>>- time arithmetic 2:32pm - 7:00am = ??
>>- storing of time value in table without having to convert to either numeric or datetime format
>>- ability to make global time format changes across app
>>
>>Basically it would like the date type now. Imagine if we could only store dates as numbers.
>>
>>I am open to debate on this subject. Fire away young Luke... I mean Mike.
>>
>>>In the wish document I saw wish for a date-less time formatt. Can anybody make this seem useful? The only time I think time could be useful is for differences and totals of datatimes, and since differences and totals of datetimes are returned in a numeric type by VFP (right?) that would destroy that reason.