Excel: Counting Hours in a Schedule

I was wondering if someone could help me develop a formula to count the hours when formatted in such a way:

Name Hours Monday Tuesday Wednesday Thursday
Name 1 =Formula 8am-8pm 10:30pm-6:15am etc etc
Name 2
Name 3
I can do it with a million LEft( and Right( but that seems terribly clunky and prone to possible error.

This question generated 38 answers. To proceed to the answers, click here.

This thread is current as of June 27, 2014.

For more resources for Microsoft Excel