Results 1 to 3 of 3

Basic Formula Not Subtracting/looking at Imported time Correctly

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-17-2008
    Location
    Vernon, CT
    Posts
    132

    Question Basic Formula Not Subtracting/looking at Imported time Correctly

    I am putting together a sheet that I will use daily. Columns A-F are imported from another program as is. This issue I am having is that the formula I wrote isn't looking at the minutes/seconds they way I thought it would. My formula:

    =if(C5>$k$2,C5-$k$2,C5)

    I highlighted the workbook to show the issue. In this example The data shows:

    C5 is [00:47:25] K2 is [0:50:00] So my answer should k5 [00:47:25], but this isn't the case. It is trying to go into a negative. I don't understand why. I tried all different types of formats and cut & paste solutions from online, but to no avail.

    Any help would be greatly appreciated.
    Attached Files Attached Files
    Last edited by jayclinton; 04-02-2014 at 09:11 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Problem with getting all the information I need imported correctly
    By THRASHER69 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-27-2014, 12:12 PM
  2. [SOLVED] Formula to add network time to leave time not working correctly
    By mlm2832 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-27-2014, 12:45 AM
  3. Replies: 3
    Last Post: 09-29-2007, 04:58 PM
  4. Imported Data, How to delimit correctly
    By GKS in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-25-2006, 02:40 PM
  5. [SOLVED] Formatting web imported data correctly
    By Bob Smith in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-23-2005, 11:15 AM

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