+ Reply to Thread
Results 1 to 4 of 4

Calculate Timings For a Day

  1. #1
    Registered User
    Join Date
    11-27-2014
    Location
    Chennai
    MS-Off Ver
    2007
    Posts
    13

    Question Calculate Timings For a Day

    I have five columns. Column A with Serial Number, Column B with Date, Column C with Time, Column D with Entry Details, Column E with Name. Need to calculate difference of IN and Out for every day. Having 40 thousand data like this in a sheet with different date ? How can we calculate ? Sample data as below for reference.

    S.No | Date | Time | Entry |Name
    1 4-Aug-14 0:36 OUT anil
    2 4-Aug-14 0:47 IN anil
    3 4-Aug-14 1:59 OUT vinoth
    4 4-Aug-14 2:01 IN vinoth
    5 4-Aug-14 2:26 OUT sharma
    6 4-Aug-14 2:28 OUT Ram
    7 4-Aug-14 2:31 IN Ram
    8 4-Aug-14 2:32 OUT jai
    9 4-Aug-14 2:41 IN sharma
    10 5-Aug-14 0:36 OUT anil
    11 5-Aug-14 0:47 IN anil
    12 5-Aug-14 1:59 OUT vinoth
    13 5-Aug-14 2:01 IN vinoth
    14 5-Aug-14 2:26 OUT sharma
    15 5-Aug-14 2:28 OUT Ram
    16 5-Aug-14 2:31 IN Ram
    17 5-Aug-14 2:32 OUT jai
    18 5-Aug-14 2:41 IN sharma

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Calculate Timings For a Day

    If you sort your table on the following:
    1.Date
    2.Time
    3.Name

    and then add the following into Column F, you'll get the differences in each IN/OUT combination. Not 100% sure however whether thats fully what you want.
    Please Login or Register  to view this content.
    If someone has helped you then please add to their Reputation

  3. #3
    Registered User
    Join Date
    11-27-2014
    Location
    Chennai
    MS-Off Ver
    2007
    Posts
    13

    Question Re: Calculate Timings For a Day

    thanks for your reply, in and out timings will be in different rows for the same name and same date , multiple in and out also possible in a date. how to proceed?

  4. #4
    Registered User
    Join Date
    11-27-2014
    Location
    Chennai
    MS-Off Ver
    2007
    Posts
    13

    Re: Calculate Timings For a Day

    solution ???? from anyone plz

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formula to compair timings
    By Liz_Biz in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 10-07-2014, 06:28 AM
  2. function to calculate the time taken between 2 timings
    By Giri.hb in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-08-2014, 11:02 PM
  3. Taking timings
    By sathishkm in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-10-2014, 11:53 AM
  4. macro that runs at set timings..
    By hotmalepiyush in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-09-2008, 01:03 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1