On Jan 16, 12:24 am, Vikas Chouhan <vikask...@gmail.com> wrote: > please provide data in excel.. > > > > On Sat, Jan 15, 2011 at 6:25 PM, herman gold <gold.her...@gmail.com> wrote: > > a1 has IN, b1 has date, and c1 has time > > a2 has OUT, b2 has date, and c2 has time > > .... > > > On Jan 15, 12:49 am, Dave Bonallack <davebonall...@hotmail.com> wrote: > > > Hi, > > > You need to tell us how this data is entered. > > > Is each line 1 cell, 2 cells, or 3 cells? > > > Regards - Dave > > > > > Date: Fri, 14 Jan 2011 23:11:40 -0800 > > > > Subject: $$Excel-Macros$$ there has to be an easier way! > > > > From: gold.her...@gmail.com > > > > To: excel-macros@googlegroups.com > > > > > Hi, > > > > > my timecard dumps an excel file with > > > > > IN 9/10/2010 8:50 > > > > OUT 9/10/2010 13:04 > > > > IN 9/10/2010 13:04 > > > > OUT 9/10/2010 17:08 > > > > IN 9/23/2010 9:08 > > > > OUT 9/23/2010 13:02 > > > > IN 9/24/2010 9:09 > > > > OUT 9/24/2010 13:08 > > > > IN 9/24/2010 13:08 > > > > OUT 9/24/2010 17:06 > > > > IN 9/30/2010 8:58 > > > > OUT 9/30/2010 13:00 > > > > > Is there a way to show me the total time worked for each day? > > > > > -- > > > --------------------------------------------------------------------------- > > ------- > > > > 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 athttp://www.excel-macros.blogspot.com > > > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > > > 5. Excel Tips and Tricks athttp://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 athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://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 > > -- > One Team One Dream One Goal > > Warm Regards, > *Vikas Chauhan* > E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com, > 9911868518, > "We can't Spell S_*ccess *without U" > > Life is Very beautiful !!! > ¨`•.•´¨) Always > `•.¸(¨`•.•´¨) Keep > (¨`•.•´¨)¸.•´ Smiling! > `•.¸.•´.
If in is A2 & out is B2 then C2 = B2 - A2 Then use cutom time frmat in the format cells option. -- ---------------------------------------------------------------------------------- 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
