Finding the time value closest to zero (with 1904 date system)

[Joe94]

I am trying to find a formula that, for each row, will display the value of the cell which is closest to 0. In order to use negative time values I have had to use the 1904 date system which I believe is disrupting the results when Excel calculates the minimum value. I have currently tried something like =MIN(ABS(A1),ABS(A2)) but this is not working. Does anyone have any suggestions as to how I can go about fixing this?

A	B
00:00:50.799	00:00:50.305
00:00:00.242	00:00:00.000
-00:00:00.860	-00:00:00.473
-00:00:01.034	-00:00:00.188
-00:00:01.266	-00:00:00.422
-00:00:00.598	00:00:00.409

<colgroup><col><col><col></colgroup><tbody>
</tbody>

Thanks

 

[Marcelo Branco]

Marcelo, try entering negative times as, for example

=-"00:00:00,473"

Probably i'm doing something silly...
I got

	A​	B​	C​
1​
2​	00:00:50,799​	00:00:50,305​	00:00:50,305​
3​	00:00:00,242​	00:00:00,000​	00:00:00,000​
4​	-9,9537E-06​	-5,47454E-06​	###############​
5​	-1,19676E-05​	-2,17593E-06​	###############​
6​	-1,46528E-05​	-4,88426E-06​	###############​

M.

 

[shg]

1904 date system?

 

[Marcelo Branco]

1904 date system?

OMG, forgot...

M.