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?

thanks

Why not save the timespans in the database as an integer value of minutes instead of a time? The database will always try to return you an actual time. An after all... 00:40:00 equals 12:40:00 AM.

You can add the minutes for "hold time" and "cycle time" to your "last entry" time by using the VBScript DateAdd function.

Peter
------------------------------------------------------
Work smarter, not harder.