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 <[email protected]>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 <[email protected]>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 [email protected] 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 -~----------~----~----~----~------~----~------~--~---
