Time calculation

Hi friends,

I have requirement like....

I have a total day (24 hrs) transactions. But at some hours transactions are not done. At that missing hours I have to show data as 0

eg:

Transaction Hours Data 1 12 2 23 3 56 5 26 6 45 9 565 10 5 12 78 13 6 14 56 15 89 16 6 17 656 18 65 19 5 20 5 22 856 23 4 24 484

I have data as above... some hours have no transaction. I want as belllow

Transaction hours Data 1 12 2 23 3 56 4 0 5 26 6 45 7 0 8 0 9 565 10 5 11 0 12 78 13 6 14 56 15 89 16 6 17 656 18 65 19 5 20 5 21 0 22 856 23 4 24 484

Please help me on this....

Regards

Riaz