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