Ive created a table with two times named cycle and hold. e.g 00:40:00 to represent 40 minutes. However when i call these in asp it displays them as 12.40.00 am, how do i change the format that it recognises that this is forty minutes not 12 in the morning. Ill also need to add these two number together to get a final time that will be used as part of a schedule ie new sceduled entry = last scheduled entry +holdtime + cycle time.
what would be the best way to do this?