Hi, Right now this is what is inside my default.cfg
################################
Mon_open => [19, 'alpha', 0, 18, 0, '', ''],
Mon_close => [20, 'alpha', 0, 18, 0, '', ''],
Tue_open => [21, 'alpha', 0, 18, 0, '', ''],
Tue_close => [22, 'alpha', 0, 18, 0, '', ''],
Wed_open => [23, 'alpha', 0, 18, 0, '', ''],
Wed_close => [24, 'alpha', 0, 18, 0, '', ''],
Thu_open => [25, 'alpha', 0, 18, 0, '', ''],
Thu_close => [26, 'alpha', 0, 18, 0, '', ''],
Fri_open => [27, 'alpha', 0, 18, 0, '', ''],
Fri_close => [28, 'alpha', 0, 18, 0, '', ''],
Sat_open => [29, 'alpha', 0, 18, 0, '', ''],
Sat_close => [30, 'alpha', 0, 18, 0, '', ''],
Sun_open => [31, 'alpha', 0, 18, 0, '', ''],
Sun_close => [32, 'alpha', 0, 18, 0, '', ''],

#in the select field I have
rMon_open => '24 Hours,CLOSED,12:00 AM,...',
rMon_close => '12:00 AM,12:15 AM,12:30,...',

Well, I can change this to military time if it will help this database to work like the way I want.

I was also hoping to add in new fields for HotLine Hours such as.

Office_mon_open
Office_mon_close
...
Office_sun_open
Office_sun_close

and

Hotline_mon_open
Hotline_mon_close
and etc.

Well I guess what I want to accomplish in the end is to allow users to do a search to see if whether an office or hotline is open at the time a search was processed.

So, "Closed" can be equal to -1, "24 Hours = X, 12:00 AM = 2400, and etc.

It would be great if you can help me get this working.
Thank you so much.

Scott Wang

Oh, and can you please explain to me on how I can make the conversion of military time to "non-military" time for display?

Thanks again.