I'm surprised at that, Ron. I'm in the UK, not the US, and I thought that
yyyy-mm-dd was accepted universally. I know that there are problems with
dd-mm-yyyy and mm-dd-yyyy, but I hadn't come across problems with
yyyy-mm-dd.
--
David Biddulph


"Ron Rosenfeld" wrote in message
...
On Fri, 9 Apr 2010 20:15:36 +0100, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

=(NOW()-TEXT(A2,"0000\-00\-00 00\:00\:00"))*24 and format the result as
General or Number.
--
David Biddulph

Note that, although that will work with US based systems, if the Windows
Regional format is set to some of the non-US formats, this will not
translate
correctly.
--ron