Calculating Start and End times

Hey everyone,

I am trying to create a time sheet and roster with excel. I have attached the template i have created

I have the layout and basic functionality of the time sheet done but i am trying to achieve 2 things that i am having trouble with.

1) with the time sheet, I am trying to calculate the difference in hours between 2 times (but i want the data to be entered in such a way where they just enter the number rather than 12:00:00opm for instance.

2) based on the time sheet i am trying to get excel to pull the information automatically onto a next worksheet where it shows the time each person worked on a graphical format so that it looks like a calendar would for instance.

Thanks in advance for the help