SalesForce does not have a Time field type for sObjects which is a real pain. I am working on a scheduling app where users and facilities specify daily blocks of time when they are available (open). So, for example: Mondays 8:00am to 12:00pm.
My first thought was a text field with specific format (hours:mins:AM/PM or 24 hour). The problem with this is that if the field is text you cannot sort on it numerically, or have formula or roll-up fields based on it. Which I need.
So now I am thinking I will need two fields, hours and minutes, for each time field. Does anyone have any clever tricks or ideas on this topic? Or do you think two fields is the way to go?
I know SF is working on a time field for a future release but that doesn't help me now :)