M
Mighty Mike
I am developing a scheduling program for my workplace. The program will
automatically calculate total time scheduled based on times entered (i.e.,
8:00AM start time in one cell, 5:00PM end time in the next cell calculates to
9 hours in a third cell). However, we need to indicate days off, vacations
and leaves of absences. When we enter text into the first cell, it obviously
destroys the calculation in the third cell. I need to be able to have Excel
assign a value of "0" for any cell that has text. Thanks, Mike
automatically calculate total time scheduled based on times entered (i.e.,
8:00AM start time in one cell, 5:00PM end time in the next cell calculates to
9 hours in a third cell). However, we need to indicate days off, vacations
and leaves of absences. When we enter text into the first cell, it obviously
destroys the calculation in the third cell. I need to be able to have Excel
assign a value of "0" for any cell that has text. Thanks, Mike