Replace a Time with same time + 1 min

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;

dd/mm/yyyy hh:mm

plus one minute

if not simply give me the original value......any ideas?

Try:

=IF($AU6867="Update",$BK6867+"0:01",$BK6867)
S

Hi,

Presumably

=IF($AU6867="Update",$BK6867+Time(0,1,0),$BK6867)

or if you prefer

=IF($AU6867="Update",$BK6867+1/1440,$BK6867)

Rgds

Maistrye

Cheers, that works and will save a few blushes, although the simplicity has caused a few!

Richard

Thanks as well, the first works and whilst I understand the logic of the second in this case it adds 30 mins which in this scenario is far too much and would upset other formulas.

Thanks to you both for you help. Much appreciated as always and I have left pos feedback for both of you.

S.