Excel 2010. I have two columns in each row for time, in hh:mm, and would like to know how to get a third column to display whichever of the first two values is nearest to 00:00. The first two columns have negative time values too (ie. they represent time before and after High Tide). for example,
<tbody>
</tbody>
02:46 | -09.39 | display here the time (with sign) nearest to 00:00 (should be 02:46) |
-01:23 | 08:35 | (should be -01:23) |
02:30 | -09.25 | (should be 02:30) |
<tbody>
</tbody>