Results 1 to 12 of 12

Looking for solution to date and time problem

Threaded View

  1. 02-02-2014, 10:50 PM #1
    budica
    budica is offline
    Registered User
    Join Date
    02-02-2014
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2007
    Posts
    6

    Looking for solution to date and time problem

    Hello, I need some help with a little problem I'm having. I have a report that I get once a week and I would like to be able to get a value for the difference in time between two cells. The problem is that this is how the data is placed in the cell.

    1/29/2014 12:45:00 AM
    1/29/2014 12:48:00 AM
    1/29/2014 12:53:00 AM
    1/29/2014 1:07:00 AM

    So because it's done as both date and time in one cell it won't let me get a serial number for the time so I can do a subtraction and find the difference. Any ideas on this one?

    THanks,
    Last edited by budica; 02-09-2014 at 12:17 AM. Reason: Solved
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Trying to find best solution that helps me dynamically update date time field
    By splahtah in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-31-2013, 05:22 AM
  2. Date and Time problem
    By E3iron in forum Excel General
    Replies: 4
    Last Post: 07-24-2009, 10:27 AM
  3. Date Time Problem - stop updating that each time the document is opened
    By Dreammy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-28-2007, 03:31 PM
  4. Date and Time Problem
    By JDBARNES63 in forum Excel General
    Replies: 1
    Last Post: 04-19-2006, 02:40 AM
  5. [SOLVED] Seeking a solution to a time-consuming problem...
    By davidd31415 in forum Excel General
    Replies: 4
    Last Post: 06-18-2005, 11:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1