Hi all
As always this is fairly time critical (no pun intended!)
I have a huge monthly export of data that is manipulated in many different ways, but one column returns two times which are both critical in different ways and often end up being the same....no problem with that, but when I sort the data based upon time I can't guarantee they'll sort in the correct order and when they don't I end up with a pile of errors because of the time sequences used on other calculations.
My solution needs to be implemented at the sort stage which is not a problem and using something similar to the following formula I simply want to add a single minute if the criteria is met;
=IF($AU6867="Update",$BK6867+1min,$BK6867)
So, the above incorrect code will hopefully give the jist of it, if the referenced cell spells out Update then give me the value which is custom formatted as;
plus one minute
if not simply give me the original value......any ideas?
Bookmarks