Hours of Operation Data extrapolation

[Christina1311]

Hi - I'm having trouble identifying a formula that will reference the first column "Hours" and populate a closed/open status & corresponding time per day of the week in a corresponding cell. Does anyone have suggestions on something that might work?

<tbody>
[TD="class: xl63"][TABLE="width: 1661"]
<tbody>[TR]
[TD="align: center"] Hours
[/TD]
[TD="align: center"] Sunday Open Status
[/TD]
[TD="align: center"] Sunday Open Time [/TD]
[TD="align: center"] Sunday Close Time [/TD]
[TD="align: center"] Monday Open Status [/TD]
[TD="align: center"] Monday Open Time
[/TD]
[TD="align: center"] Monday Close Time [/TD]
[TD="align: center"] Tuesday Open Status [/TD]
[TD="align: center"] Tuesday Open Time
[/TD]
[TD="align: center"] Tuesday Close Time [/TD]
[TD="align: center"] Wednesday Open Status [/TD]
[TD="align: center"] Wednesday Open Time [/TD]
[TD="align: center"] Wednesday Close Time [/TD]
[TD="align: center"] Thursday Open Status [/TD]
[TD="align: center"] Thursday Open Time [/TD]
[TD="align: center"] Thursday Close Time [/TD]
[TD="align: center"] Friday Open Status [/TD]
[TD="align: center"] Friday Open Time [/TD]
[TD="align: center"] Friday Close Time [/TD]
[TD="align: center"] Saturday Open Status [/TD]
[TD="align: center"] Saturday Open Time [/TD]
[TD="align: center"] Saturday Close Time [/TD]

[TD="align: center"] Mon-Sat:10am-9pm,Sun:11am-7pm [/TD]
[TD="align: center"] closed
[/TD]
[TD="align: center"] closed [/TD]
[TD="align: center"] closed [/TD]
[TD="align: center"] open [/TD]
[TD="align: center"] 10:00 AM [/TD]
[TD="align: center"] 8:00 PM [/TD]
[TD="align: center"] open [/TD]
[TD="align: center"] 10:00 AM [/TD]
[TD="align: center"] 8:00 PM [/TD]
[TD="align: center"] open [/TD]
[TD="align: center"] 10:00 AM [/TD]
[TD="align: center"] 8:00 PM [/TD]
[TD="align: center"] open [/TD]
[TD="align: center"] 10:00 AM [/TD]
[TD="align: center"] 8:00 PM [/TD]
[TD="align: center"] open [/TD]
[TD="align: center"] 10:00 AM [/TD]
[TD="align: center"] 2:00 PM [/TD]
[TD="align: center"] open [/TD]
[TD="align: center"] 9:00 AM [/TD]
[TD="align: center"] 1:00 PM [/TD]

[TD="align: center"] Mon-Thu:10am-8pm,Fri-Sat:10am-9pm,Sun:12pm-7pm [/TD]
[TD="align: center"] closed [/TD]
[TD="align: center"] closed [/TD]
[TD="align: center"] closed [/TD]
[TD="align: center"] open [/TD]
[TD="align: center"] 10:00 AM [/TD]
[TD="align: center"] 8:00 PM [/TD]
[TD="align: center"] open [/TD]
[TD="align: center"] 10:00 AM [/TD]
[TD="align: center"] 8:00 PM [/TD]
[TD="align: center"] open [/TD]
[TD="align: center"] 10:00 AM [/TD]
[TD="align: center"] 8:00 PM [/TD]
[TD="align: center"] open [/TD]
[TD="align: center"] 10:00 AM [/TD]
[TD="align: center"] 8:00 PM [/TD]
[TD="align: center"] closed [/TD]
[TD="align: center"] 1:46 PM [/TD]
[TD="align: center"] 1:46 PM [/TD]
[TD="align: center"] open [/TD]
[TD="align: center"] 10:00 AM [/TD]
[TD="align: center"] 4:00 PM [/TD]

[TD="align: center"] Mon-Sat:10am-9:30pm,Sun:11am-7pm [/TD]
[TD="align: center"] closed [/TD]
[TD="align: center"] closed [/TD]
[TD="align: center"] closed [/TD]
[TD="align: center"] open [/TD]
[TD="align: center"] 11:00 AM [/TD]
[TD="align: center"] 7:00 PM [/TD]
[TD="align: center"] open [/TD]
[TD="align: center"] 11:00 AM [/TD]
[TD="align: center"] 8:00 PM [/TD]
[TD="align: center"] open [/TD]
[TD="align: center"] 11:00 AM [/TD]
[TD="align: center"] 7:00 PM [/TD]
[TD="align: center"] open [/TD]
[TD="align: center"] 11:00 AM [/TD]
[TD="align: center"] 8:00 PM [/TD]
[TD="align: center"] open [/TD]
[TD="align: center"] 10:00 AM [/TD]
[TD="align: center"] 2:00 PM [/TD]
[TD="align: center"] open [/TD]
[TD="align: center"] 10:00 AM [/TD]
[TD="align: center"] 2:00 PM [/TD]

[TD="align: center"] Mon-Sat:10am-9pm,Sun:11am-6pm [/TD]
[TD="align: center"] closed [/TD]
[TD="align: center"] closed [/TD]
[TD="align: center"] closed [/TD]
[TD="align: center"] open [/TD]
[TD="align: center"] 10:00 AM [/TD]
[TD="align: center"] 7:30 PM [/TD]
[TD="align: center"] open [/TD]
[TD="align: center"] 10:00 AM [/TD]
[TD="align: center"] 7:30 PM
[/TD]
[TD="align: center"] open [/TD]
[TD="align: center"] 10:00 AM [/TD]
[TD="align: center"] 7:30 PM [/TD]
[TD="align: center"] open [/TD]
[TD="align: center"] 10:00 AM [/TD]
[TD="align: center"] 7:30 PM [/TD]
[TD="align: center"] open [/TD]
[TD="align: center"] 10:00 AM [/TD]
[TD="align: center"] 4:00 PM [/TD]
[TD="align: center"] open [/TD]
[TD="align: center"] 10:00 AM [/TD]
[TD="align: center"] 12:00 PM [/TD]

[TD="align: center"] Mon-Sat:10am-9pm,Sun:11am-7pm [/TD]
[TD="align: center"] closed [/TD]
[TD="align: center"] closed [/TD]
[TD="align: center"] closed [/TD]
[TD="align: center"] open [/TD]
[TD="align: center"] 10:00 AM [/TD]
[TD="align: center"] 7:30 PM [/TD]
[TD="align: center"] open [/TD]
[TD="align: center"] 10:00 AM [/TD]
[TD="align: center"] 7:30 PM [/TD]
[TD="align: center"] open [/TD]
[TD="align: center"] 10:00 AM [/TD]
[TD="align: center"] 7:30 PM [/TD]
[TD="align: center"] open [/TD]
[TD="align: center"] 10:00 AM [/TD]
[TD="align: center"] 7:30 PM [/TD]
[TD="align: center"] open [/TD]
[TD="align: center"] 10:00 AM [/TD]
[TD="align: center"] 4:00 PM [/TD]
[TD="align: center"] open [/TD]
[TD="align: center"] 9:30 AM [/TD]
[TD="align: center"] 11:30 AM [/TD]

</tbody>

[/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl63, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[/TR]
</tbody>[/TABLE]