With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Wednesday, December 31, 2014
yogi_Calculate Total Hours Scheduled In Employee Schedule With Text Representing Days Off
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?