SUM Hrs:Mins

[scoobyblue]

I have a spreadsheet where I record details of clients I work for, totalling time worked per day. Above all the data I want a few boxes where I can enter a start & end date, client name and a calculation (sumproduct or something) to total the hours for that client from the start to end date inclusive. So by changing the dates and client name I can quickly identify hours worked.

Data column headlines as follows;

DATE CLIENT HRS:MINS

Hope all is clear, many thanks for any assistance.

Regards,
scoobyblue

 

[VoG]

Try like this. Format the result cell as Custom [h]:mm

=SUMPRODUCT(--(A2:A100>="1/4/2011"+0),--(A2:A100<="30/5/2011"+0),--(B2:B100="Mr X"),C2:C100)

 

[scoobyblue]

Hi,
Thanks for quick reply - I used your formula exactly and the total came to 12:25 (12hrs 25mins), when it should have read 36:25.

Any ideas?

Thanks.

 

[VoG]

You need to format the cell as [h]:mm as I said.

 

[scoobyblue]

Sorry, I'd copied the formatting from a cell that was showing hrs:mins so assumed it was formatted correctly - it works now, many thanks.