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 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
