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?

[TABLE="width: 310"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00:00:50.799[/TD]
[TD]00:00:50.305[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00:00:00.242[/TD]
[TD]00:00:00.000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]-00:00:00.860[/TD]
[TD]-00:00:00.473[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]-00:00:01.034[/TD]
[TD]-00:00:00.188[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]-00:00:01.266[/TD]
[TD]-00:00:00.422[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]-00:00:00.598[/TD]
[TD]00:00:00.409[/TD]
[/TR]
</tbody>[/TABLE]

Thanks

 

[Marcelo Branco]

Marcelo, try entering negative times as, for example

=-"00:00:00,473"

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

[Table="class: grid"][tr][td="bgcolor: #DCE6F1"][/td][td="bgcolor: #DCE6F1"]

A​

[/td][td="bgcolor: #DCE6F1"]

B​

[/td][td="bgcolor: #DCE6F1"]

C​

[/td][/tr]
[tr][td="bgcolor: #DCE6F1"]

1​

[/td][td][/td][td][/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

2​

[/td][td]

00:00:50,799​

[/td][td]

00:00:50,305​

[/td][td]

00:00:50,305​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

3​

[/td][td]

00:00:00,242​

[/td][td]

00:00:00,000​

[/td][td]

00:00:00,000​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

4​

[/td][td]

-9,9537E-06​

[/td][td]

-5,47454E-06​

[/td][td]

###############​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

5​

[/td][td]

-1,19676E-05​

[/td][td]

-2,17593E-06​

[/td][td]

###############​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

6​

[/td][td]

-1,46528E-05​

[/td][td]

-4,88426E-06​

[/td][td]

###############​

[/td][/tr]
[/table]



M.

 

[shg]

1904 date system?

 

[Marcelo Branco]

1904 date system?

OMG, forgot...

M.