(Help) Time Sheet total hours worked per day and overall week

[SirDraco]

Hello,

I am having difficulty with sorting out a time sheet.

We have 8 tabs
Tab 1 - Hours
Tab 2 - Sunday
Tab 3 - Monday
Tab 4 - Tuesday
Tab 5 - Wednesday
Tab 6 - Thursday
Tab 7 - Friday
Tab 8 - Saturday

The hours tab is split down for each day and will look up all the names for each day. (staff change over the week or change location on sheet.)

then on the hours tab we lookup the date and person name to find the start hours and end hours and should then show total time worked

E.g
Start Time 3.30pm
End Time 6.30am
Total Time 15.00

Start Time 6.30am
End Time 3.30am
Total Time 9.00

At the moment for this to work on the individual day tab i am having to put Start Time 4/4/10 15:30 End Time 5/4/10 6:30
Then on the hours i have a tab just after the start and end that gets the number value of the date and is times by 24 then the total is worked out by taking away the numbers. (is there a way where i can just but the hours in with out the date?)

Then on the hours tab there is a weekly total. This has all the agents names it will then look up each day and fill in the hours for the agents each day.
It will then show total hours for each day as well as total hours for staff per week along with all staff total hours.

I would also like it to not show 12:00am if there is no agent or hours worked and would like it if its 0 hours worked to leave the cell blank.

I have noticed that at moment for like 2 hours 15 mins it will show as 2.25 which is there a way to get it to display as 2 hours 15mins in the total hours box?

*The Sunday to Saturday tabs would have alot of other data on but to work on this i have just gone with the basic information.

Time Sheet.xlsx

Thanks for any help given.