+ Reply to Thread
Results 1 to 7 of 7

Calculate Date between Two Different Time Stamps

Hybrid View

  1. #1
    Valued Forum Contributor Root_'s Avatar
    Join Date
    07-29-2017
    Location
    _
    MS-Off Ver
    2010+
    Posts
    514

    Re: Calculate Date between Two Different Time Stamps

    Try

    =B2-1/3 formatted as date, or
    =INT(B2-1/3) if you don't want the time portion

  2. #2
    Registered User
    Join Date
    06-20-2018
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    3

    Re: Calculate Date between Two Different Time Stamps

    So i have the date and time stamps in column C... need the results as in Column B ( i have manually entered it now).. change in date required refer to Row 8

    1 18/06/2018 16/06/2018 16:15
    2 18/06/2018 17/06/2018 16:30
    3 18/06/2018 18/06/2018 16:45
    4 18/06/2018 19/06/2018 17:00
    5 18/06/2018 19/06/2018 17:15
    6 18/06/2018 19/06/2018 17:30
    7 18/06/2018 19/06/2018 17:45
    8 19/06/2018 19/06/2018 18:00
    9 19/06/2018 19/06/2018 18:30
    10 19/06/2018 19/06/2018 18:45
    11 19/06/2018 19/06/2018 19:00
    12 19/06/2018 19/06/2018 19:15
    13 19/06/2018 19/06/2018 19:30
    14 19/06/2018 19/06/2018 19:45

+ 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] Calculate total hours worked between 2 date/time stamps ignoring weekends and holidays
    By drewship in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-01-2015, 09:59 AM
  2. Replies: 2
    Last Post: 06-13-2014, 10:07 PM
  3. Formula to calculate date and time stamps + lunch
    By excelgeezer in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-02-2013, 05:35 AM
  4. Excel 2007 : Difference between two Date Time Stamps
    By Sedlacek2001 in forum Excel General
    Replies: 3
    Last Post: 05-15-2012, 11:12 AM
  5. Calculate difference between two time stamps...
    By chi11 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-21-2011, 09:31 PM
  6. Time Difference in hours between two date time stamps
    By Cipher in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-17-2010, 10:24 AM
  7. Difference between two Excel Date/Time Stamps
    By lnapier in forum Excel Formulas & Functions
    Replies: 51
    Last Post: 09-06-2005, 12:05 PM

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