Sathish, Try ownloading the following file: http://www.scribd.com/doc/5402351/Personnel-Timesheet-081207
Let me know if this helps. Norman On Sat, Nov 22, 2008 at 9:16 AM, Sathish Jalendran <[EMAIL PROTECTED]>wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
