hello xl xperts,
I'm back again. I was able to get some help from one of the xl x-perts here a while ago. He was able to provide me a working formula which is:
Formula works in away that it displays the statement "ON TIME" if the difference of time1 and time2 is less than 15 minutes...However if the diffrence between time1 and time2 is greater than 15minutes then it will display the exceeded minutes like "00:05" What I would like to do now is, is there anyway that when cells in time1 and time2 are empty then the expression is blank? currently if I copy the entire formula in a range of cells, it gives a default value of "On Time" even though cells in time1 and time2 are blank. I would like to have the cell with the formula above blank, while cells in time1 and time2 are empty. I appreciate any assistance.
Thanks,
Burke
Bookmarks