Results 1 to 4 of 4

Subtracting two cells that have time and date

Threaded View

  1. #1
    Registered User
    Join Date
    03-06-2012
    Location
    atlanta, Georgia
    MS-Off Ver
    Excel 2010
    Posts
    1

    Subtracting two cells that have time and date

    hey guys im really stuck.I have a bunch of data that has 2 columns, each with time and date information. I need to subtract one column from another, and need just the difference in time, in units of minutes. for example, i would need to subtract:

    [2012-02-14 18:31:00.000] - [2012-02-14 07:26:00.000] = [785]

    does anyone know how to do this? Thank in advance. I've attached a small sample of the two colums
    Attached Images Attached Images
    Last edited by phob; 03-06-2012 at 10:08 PM.

Thread Information

Users Browsing this Thread

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

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