Anand thanks for the help but the condition is if it should not consider the time after normal working hours that is 8am to 8pm
Regards Sathish Jalendran -----Original Message----- From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of anandydr Sent: 22 November 2008 04:46 pm To: MS Excel & VBA Macros Subject: $$Excel-Macros$$ Re: Worked hour difference calculation If you want to use the same sheet that you have sent you can use the formula =IF(LEFT(A1,10)=LEFT(B1,10),RIGHT(B1,8)-RIGHT(A1,8),RIGHT(A1,8)-RIGHT (B1,8)) When pasted in cell C1 this will calculate the number of hours worked. Set the format of C1 cell to hh:mm:ss and you can see the correct result. Hope that helps, Anand 09971050827 On Nov 21, 10:06 am, "konark vyas" <[EMAIL PROTECTED]> wrote: > Dear Satish, > > FInd attached is the solution. have doe it in the first row. Kindly put the > time and and time out figures for the rest of the cells > > Regards, > > Konark Vyas > > On 11/21/08, Sathish Jalendran <[EMAIL PROTECTED]> wrote: > > > > > > > Hi, > > > Can you please let me know how to find the actual worked hour difference > > between 2 dates have attached the sample file my day starts at 8 am in the > > morning and ends at 8pm in the evening > > > Regards > > > Sathish Jalendran > > > The information contained in this electronic message and any attachments to > > this message are intended for the exclusive use of the addressee(s) and may > > contain proprietary, confidential or privileged information. If you are not > > the intended recipient, you should not disseminate, distribute or copy this > > e-mail. Please notify the sender immediately and destroy all copies of this > > message and any attachments contained in it. > > > > time diff(1).xls > 204KViewDownload- Hide quoted text - > > - Show quoted text - The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments contained in it. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
