Re: Date & time substraction

Giganews Newsgroups
Subject: Re: Date & time substraction
Posted by:  Rick Rothstein \(MVP - VB\) (rick.newsNO.SP…@NO.SPAMverizon.net)
Date: Thu, 17 Jul 2008

Assuming you want hours as a floating point number...

=24*(A2-A1)

Rick

"VINAY DALMIA" <VIN…@newsgroup.nospam> wrote in message
news:OymHUFB6IHA.48…@TK2MSFTNGP03.phx.gbl...
> Cell A1  13/01/2008 10:25 AM
>
> Cell A2  17/01/2008 06:10 PM
>
> How to acheive difference between cell A2 & A1 in hours?
>
> Thanks in advance
>
> Vinay Dalmia

Replies

None

In response to

Date & time substraction posted by VINAY DALMIA on Thu, 17 Jul 2008