Blitskrieg
10-21-2011, 03:25 PM
Greetings All.
Here's what I'm trying to put into a Do While/Loop but it's not working.
I have a Column "D" in my worksheet that contains a time in the format 0:00:00. When trying to average these times #div/0 is returned. But If i hit F2 and then Enter to move through the cells the formula calculates correctly but the cells become 0:00:00 AM. I've tried messing with formats to no avail.
Here's what I'm trying to put into a Do While/Loop but it's not working.
I have a Column "D" in my worksheet that contains a time in the format 0:00:00. When trying to average these times #div/0 is returned. But If i hit F2 and then Enter to move through the cells the formula calculates correctly but the cells become 0:00:00 AM. I've tried messing with formats to no avail.