tot. hrs worked weekly equation?

Question

i am trying to make an equation to add total hrs worked weekly. i can get the one for tot hrs daily or within 24hrs but i cant get the one for total hrs weekly. pls help

i know how to add the hrs manually but i need to know how to write the equation to add them in excel. everytime the total hrs go over 24hrs it keeps adding it as is its a new day. i need an equation that can add all the hrs worked weekly in 00:00 format eg. 42:20

Answer 1

For overtime purposes, a company can define the week as starting anytime they want to, and ending seven days later. They should define to you what a "workweek" is if it's not the traditional Sunday morning through Saturday evening.

Add up the working hours for the seven days in your week, and you'll have your weekly hours worked.

Answer 2

TOTAL HOURS WEEKLY =

TOTAL HOURS SUNDAY +
TOTAL HOURS MONDAY +
TOTAL HOURS TUESDAY +
TOTAL HOURS WEDNESDAY +
TOTAL HOURS THURSDAY +
TOTAL HOURS FRIDAY +
TOTAL HOURS SATURDAY