>Jim,
>
>I need to, for example, store the time interval ( 2:30 PM - 5:00 PM) that this particular customer is available. I need to be able to check for conflicts using that data. So I can't store it as a string.
>
>Gnana

Gnana,

Is the customer available 2:30 to 5:00 every day or on some specific day? IOW, you can use a DateTiem and only look at the time protion, or with a DateTime you can say the customer is available between 2:30-5:00 on a given day.