Strange UNIX2DATE results

[John Coppens <john jcoppens com>]

Hi...

I'm not sure if I'm doing something wrong here.

I have a column with experiment times (in decimal hours - derived from
Unix C time). I try to convert them to date/time using UNIX2DATE and get
erratic results with this formula:

=unix2date(A5*3600)

Examples:

   -- A ---     --- B ---
297244.954444 11/30/03 1:54
297244.957222 11/30/03 1:56
297244.960000 11/29/03 1:57
297244.962778 11/29/03 1:58
297244.965556 11/29/03 2:00
297244.968300 11/30/03 1:56

The A column seems to increment nicely - the B column jumps around (near
the correct date though)

Ideas?

John