AJ,

Thanks, this is exactly what i was looking for

Thanks

Harry

On Mar 7, 10:53 pm, Abhishek Jain <abhishek....@gmail.com> wrote:
> Dear Harpreet,
>
> Check the sample file attached. Format used is - "[h]:mm" (without quotes).
>
> Cheers!
>
> AJ
>
> On Sun, Mar 7, 2010 at 12:42 PM, Harpreet Singh Gujral <
>
>
>
> harpreetguj...@gmail.com> wrote:
> > Ayush,
>
> > I tried your solution, it works to some extent, but it doesnt work if
> > the date and time in B1, is more by 24 hours.
>
> > Can you check on my behalf:
>
> > 1) 11/12/2009 09:00 and 11/12/2009 10:00
> > 2) 11/12/2009 09:00 and 11/12/2009 14:00
> > 3) 11/12/2009 09:00 and 12/12/2009 09:00
> > The first date goes into cell A1 and the second goes in to cell B1,
> > and C1 calculates a difference.
> > Point 1) should give 1hour as the output in cell C1
> > Point 2) Should give 05hours as the output in cell C1
> > Point 3) Should give 24 hours as the output in cell C1
>
> > Please advise
>
> > Thanks
>
> > Harpreet Gujral
>
> > On Mar 6, 5:19 pm, Ayush <jainayus...@gmail.com> wrote:
> > > Hi Harpreet,
>
> > > Simply you can use B1-A1 and change the time format to "1:00". It
> > > should work.
> > > Let us know if you have any further questions.
>
> > > Best regards,
> > > Ayush Jain
>
> > > On Mar 6, 3:38 pm, Harpreet Singh Gujral <harpreetguj...@gmail.com>
> > > wrote:
>
> > > > Hi Group,
>
> > > > I have the following question:
>
> > > > I have two cells, both have the following formating. "DD/MM/YYYY
> > HH:MM".
>
> > > > Suppose, CellA1 has time "11/12/2009 09:00" while cell B1 has the
> > following
> > > > value "11/12/2009 10:00". Can we find a diff in cell C1. The actual
> > > > difference would be 1hr.
> > > > Actually, what i am looking at is, Cell A1 consists of my deadline,
> > while
> > > > Cell B1 consists of the actuall time. All i want to know is that, what
> > was
> > > > the time which it got delayed.
>
> > > > Thanks
>
> > > > Harpreet Gujral- Hide quoted text -
>
> > > - Show quoted text -
>
> > --
>
> > ---------------------------------------------------------------------------­-------
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our Facebook Group @
> >http://www.facebook.com/group.php?gid=287779555678
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
>
> > We reach over 6,800 subscribers worldwide and receive many nice notes about
> > the learning and support from the group.Let friends and co-workers know they
> > can subscribe to group at
> >http://groups.google.com/group/excel-macros/subscribe
>
>
>
>  format.xls
> 23KViewDownload- Hide quoted text -
>
> - Show quoted text -

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Reply via email to