Valid dates, and dynamic row counting
Posted by Ryan on July 23, 2001 6:55 AM
I need to figure out if the values in cells A1 and B1 are a valid date/time (07/20/01 7:59:25) (07/20/01 8:10:59) if they are I need to subtrack the two to get the time differnce in C1. If they either one is not a valid date then I need to populate the cell C1 with a '0'
I also need to (from another sheet) count how many rows are populated with the results of the above that are not equal to '0'.
Can you give me some pointers on what I need to do here?