The formula did not work and I think it is due to the way I have time formatted. I used the drop down menu in Excel and selected the format 13:30 which I thought was military time but times in my spread sheet less than 12 pm did not have 0 (e.g., 0930). The time in the cell was 9:30. I tried other formats and none work. Any thoughts?