How to populate daily data in 24 hour format into Excel?

[DorothyFan1]

I have a problem. I've come across a situation in my office where they want me to enter data across columns depending on the hour and the department the data comes from. For instance there are 4 departments and each one can have data entered on it's own row depending on the hour it was commissioned for. So there are 24 hours in the day and data gets populated depending on when it was noted. Is there an easier way to enter this data without getting cross eyed in determining where to place the data in the rows?

Here's a simple example

Accounting
Finance
Marketing
Human Resources

Each department can have someone doing something in a 24 hour span and I need to enter this by populating the rows across with the headers listing the hours...in 24 hour format. There's got to be an easier way to do this. Any suggestions would be greatly appreciated.