Try this formula =(DATEDIF(A1,B1,"D")*24+INT(TEXT((B1-A1),"H")))&":"&RIGHT(TEXT((B1-A1),"H:MM"),2)
Let me know if it does not help you. On Tue, Dec 23, 2008 at 3:30 PM, Santhosh Kumar M K <mks....@gmail.com>wrote: > Hai Ajay, > > My question is > > Cell A1 = 12/20/2008 5:25:00 AM > Cell B1 = 12/23/2008 1:00:00 PM > > > calculate the number of hours and minutes between these above two dates. > > Answer Formate = __ *:* __ (hh*:*mm) > > > Thanks for your help. > > Rgds, > > Sunny > On Fri, Dec 19, 2008 at 3:19 PM, Ajay Varshney < > ajayvarshney21...@gmail.com> wrote: > >> Use this formula >> >> =DATEDIF(A1,B1,"D")*24 >>>> This if for calculating hours between two >> dates. >> =DATEDIF(A1,B1,"D")*24*60 >>>> This is for calculating minutes between two >> dates. >> >> Assumption : Cell "A1" has Start date and Cell "B1" has End date. >> >> >> >> >> >> On Fri, Dec 19, 2008 at 11:10 AM, Santhosh Kumar M K >> <mks....@gmail.com>wrote: >> >>> Dear Friends, >>> >>> Please, send formula....reqarding the above suject....... >>> >>> Regards, >>> >>> Santhosh >>> >>> >> >> >> >> > --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
