I have in cells A1,A8,A15,A22 etc the time a document was printed.
In cells A2,A9,A16,A23 etc I have a formula counting how much time has elapsed since the document was printed.
I have created a named range from A1 up to A99 for the cells with the elapsed time.
When I use the LARGE function to display the highest elapsed time value it displays the current time. What I require is for the formula to calculate the values if the time the document was printed is entered. For example if cells A1,A8 and A15 have the time a document was printed entered and A22 is still blank only take into account the time elapsed in cells A2,A9 and A16.
Thanks
In cells A2,A9,A16,A23 etc I have a formula counting how much time has elapsed since the document was printed.
I have created a named range from A1 up to A99 for the cells with the elapsed time.
When I use the LARGE function to display the highest elapsed time value it displays the current time. What I require is for the formula to calculate the values if the time the document was printed is entered. For example if cells A1,A8 and A15 have the time a document was printed entered and A22 is still blank only take into account the time elapsed in cells A2,A9 and A16.
Thanks