calculations on time sheet

[Kat Donnelly]

I have attached a time sheet and there are really three things I need done...

1) I would like job hours for the week to calculate to the Job Name section for a total number of hours for that job for the week. (I had a different use for this time sheet so there is some sort of formula that I used for that in there but this is a little more simplified and I don't know how to adjust - I have removed items from the sheet)

2) My total hours (Line 33) don't calculate correctly not sure why

3) Is there a way to add a calendar into the date box so that they can just click the date or do they always have to key in?

Thanks for any help on any of these...

Kat

[davesexcel]

The cells with sum formulas need to be formatted as [h]:00
Check out your example.

Check out the data validation for the Dates

[newdoverman]

This solution uses SUMPRODUCT.

[Kat Donnelly]

Solved for me! Thanks!