C1 = B1-A1 this will show u result like this 03-01-1900 7:35:00 AM now go to format cell go to time on Number Tab.... select 37:30:55
this will show u ans as *79:35:00* ** *any query mail me... or call me +919924321990* ** enjoy... Regards, Viral Pandya I am not programmer, I am just an end-user perfect end-user!!! On 12/23/08, 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 -~----------~----~----~----~------~----~------~--~---
