Hi, U can use DAYS360 formula................
Regards Naveen Kumar M N Transport Supervisor(HP) 91-08-99728 10886 Email :[EMAIL PROTECTED] Best Wishes-Karunaada Kuvara --- On Sun, 11/23/08, Norman <[EMAIL PROTECTED]> wrote: From: Norman <[EMAIL PROTECTED]> Subject: $$Excel-Macros$$ Re: Worked hour difference calculation To: "MS Excel & VBA Macros" <excel-macros@googlegroups.com> Date: Sunday, November 23, 2008, 4:42 PM Sathish, Try ownloading the following file: http://www.scribd.com/doc/5402351/Personnel-Timesheet-081207 Let me know if this helps. Norman On Nov 20, 11:36 pm, "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 deff.xls > 181KViewDownload --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
