Adding up times to get a total amout of hours

[ECEK]

I have a table of hours that have been worked by employees for each day of the week

[moh] (Monday's hours),[tuh],[weh],[thh],[frh],[sah],[suh]
data eg (this is how I would like it to be inputted into the table)
7:24:00,7:24:00,7:24:00,7:24:00,7:22:00,0:00:00,0:00:00

This equates to 36:58:00

I have tried

Total Hours: [moh]+[tuh]+[weh]+[thh]+[frh]+[sah]+[suh]

but Im struggling to get what I want in the right format.

Could you please help with either the formatting or how to record the initial data or a formula to format the end result.

Excel just does it !!!!!

 

[pr2-eugin]

Okay I am just going to say it. You have mixed up Excel with Access. They are two different applications, with merits and demerits of their own. When it comes to access - it is a Relational Database, unlike Excel. When it comes to Access concepts of Normalization have to be looked into.

The current structure is not normalized and can cause a lit of trouble along the lines.