I am using Access 2007 and I ma having a time with the format. I have tried to display the sum of hours where the number of hours exceed 24 hours. There is one accumulation of hours which should total 130:30 for Contract. Instead, I get 10:30. Likewise, I should also get 128:00 total hours for GSC Recording, instead, I get 8:00.
I am using an excel spreadsheet at the table. I have given the field properties for the Data Type of Date/Time the format of: \[hh\]:nn
The calculated hours is the same format.
The query that I am using displays the sum of the Calculated hours based on the grouping of type and this is where I would like for when the total is greater than 24 hours to show. Can you assist me please? Thank you.