How to count time hourly for everyday

I have a table with column name Id fOrmtime totime mon tues wed Thur Fri 1 12:00am 1:00am 1 0 0 0 0 2 1:00am 2:00am 1 0 0 0 0 3 2:00am 3:00am 1 0 0 1 0 4 3:00am 4:00am 0 1 1 1 0 5 4:00am 5:00am 1 0 1 1 0 Output: mon:0-3;4-5; Tue:3-4; Wed:3-5; Thur:2-5; I need this type of output.please help