Calculating Weekly Total Hours from Daily Times

Hello all, I am needing some help trying to figure out the right method of going by calculating times from a single cell and adding the totals for the week at the end of the cells.

Example:
Sat - E2= 0700 - 1500
Sun - F2= 0700 - 1530
Mon - G2= 0500 - 1330
Tue - H2= 0700 - 1500
Wed - I2= 0700 - 1500
Thu - J2= 0700 - 1500
Fri - K2= 0700 - 1500
Weekly Totals (in hours) L2= (total hours)

Sample Excel.jpg

Thank you for all your help!!

Try this in L2:

=SUM(IF(E2:K2<>"",TEXT(RIGHT(E2:K2,4),"00\:00")-TEXT(LEFT(E2:K2,4),"00\:00"),""))

Array formula.
Enter with Ctrl+Shift+Enter
custom format: [h]:mm

Phuocam your a life saver, thank you very much!!

You're welcome.

Another question for this formula...
=SUM(IF(E2:K2<>"",TEXT(RIGHT(E2:K2,4),"00\:00")-TEXT(LEFT(E2:K2,4),"00\:00"),""))
How can i remove 30 minutes from each day? Sorry i forgot all about this factor.

30 minutes = 1/2 hour = 1/48 day

=SUM(IF(E2:K2<>"",TEXT(RIGHT(E2:K2,4),"00\:00")-TEXT(LEFT(E2:K2,4),"00\:00"),""))-COUNTA(E2:K2)*1/48
Enter with Ctrl+Shift+Enter
Custom format: [h]:mm

Is there a way to ignore the -COUNTA(E2:K2)*1/48 if the time is under lets say 4 hours?

Yes.

=SUM(IF(E2:K2<>"",TEXT(RIGHT(E2:K2,4),"00\:00")-TEXT(LEFT(E2:K2,4),"00\:00")
-(TEXT(RIGHT(E2:K2,4),"00\:00")-TEXT(LEFT(E2:K2,4),"00\:00")>=4/24)*1/48,""))

Enter with Ctrl+Shift+Enter