HI, Some cells have a date & hour value (eg. Cell Q4 have a value of 40548.8576388889, that is 05/01/2011 20:35:00 when P4 only has the hour part).
Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Born to Win Envoyé : vendredi 22 avril 2011 21:37 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ Attached File contains Lgin Lgout Detail Due to wrong Time format i am not able to get correct report please suggest if possible. Hi Experts, Attached File contains Lgin Lgout Detail of employee and i want to know total & average staffing for each employee however i tried to use some basic fucntion but i am getting wrong report i believe due to wrong format i am getting wrong report.is their any way.. Please suggest its really important please help me out. Thanks, Prabhat Kumar -- ---------------------------------------------------------------------------- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
