Re: $$Excel-Macros$$ Re: Finding a diff b/w two time
You're welcome Harry. :-) On Thu, Mar 11, 2010 at 11:34 PM, Harpreet Singh Gujral < harpreetguj...@gmail.com> wrote: > AJ, > > Thanks, this is exactly what i was looking for > > Thanks > > Harry > > On Mar 7, 10:53 pm, Abhishek Jain 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 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 > > > > wrote: > > > > > > > Hi Group, > > > > > > > I have the following question: > > > > > > > I have two cells, both have the following formating. "DD/MM/ > > > 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 > -- -- 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
Re: $$Excel-Macros$$ Re: Finding a diff b/w two time
AJ, Thanks, this is exactly what i was looking for Thanks Harry On Mar 7, 10:53 pm, Abhishek Jain 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 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 > > > wrote: > > > > > Hi Group, > > > > > I have the following question: > > > > > I have two cells, both have the following formating. "DD/MM/ > > 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
Re: $$Excel-Macros$$ Re: Finding a diff b/w two time
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 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 > > wrote: > > > > > > > > > Hi Group, > > > > > I have the following question: > > > > > I have two cells, both have the following formating. "DD/MM/ > 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 > -- -- 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 format.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Re: Finding a diff b/w two time
right click on cell click on format cell-> choose the custom format -> nad type this [hh]:mm 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 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 > > wrote: > > > > > > > > > Hi Group, > > > > > I have the following question: > > > > > I have two cells, both have the following formating. "DD/MM/ > 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 > -- -- 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
Re: $$Excel-Macros$$ Re: Finding a diff b/w two time
Hi Frnds, i also have same Query As mentioned i tried for the B1-A1 but its not working.as it contains date and time also,one of my frnd has made macro for the same.i wil gv it to u tomorrow. On 3/6/10, Ayush 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 > wrote: >> Hi Group, >> >> I have the following question: >> >> I have two cells, both have the following formating. "DD/MM/ 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 > > -- > -- > 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 > -- -- 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
$$Excel-Macros$$ Re: Finding a diff b/w two time
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 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 > wrote: > > > > > Hi Group, > > > I have the following question: > > > I have two cells, both have the following formating. "DD/MM/ 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
$$Excel-Macros$$ Re: Finding a diff b/w two time
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 wrote: > Hi Group, > > I have the following question: > > I have two cells, both have the following formating. "DD/MM/ 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 -- -- 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