yogi_Calculate Total Hours Scheduled In Employee Schedule With Text Representing Days Off

             Google Spreadsheet   Post  #1870

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-31-2014

post by  Joseph Hipp:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!category-topic/docs/spreadsheets/7vKPKqPovkc
Calculate total hours scheduled in Employee schedule w/ text representing days off

Ok, I am trying to create a spread sheet to make my employee schedule on. When I have a requested day off, I want to be able to enter text into the appropriate collum to indicate this. However, this causes an error with my formula.

Also, I tried formatting the appropriate cells to time, but when I enter values, it reverts back to plain text :( I need the time format, because I have some hours which are halves (i.e. 22:30)

Here is what I have, can someone please help me make the formulas work?

https://docs.google.com/spreadsheets/d/1CRZiHtry_IWj1SZu7TIy7IWupBVU3OldIl3Qq9lElmo/edit#gid=0

Thank you in advance.

--------------------------------------------------------------------------------------------------------------------------------------