Results 1 to 2 of 2

Time Type Not Matching

Threaded View

  1. #1
    Registered User
    Join Date
    05-13-2010
    Location
    Bellingham, Washington
    MS-Off Ver
    Excel 2007
    Posts
    12

    Time Type Not Matching

    I have a spreadsheet in which I am using data combined from two separate resources (as seen on Phone Log and System Log sheets). I am combining the information into the Details sheet. From here I need to create a formula, as seen in J10 of Details, that will indicate if the info in column D is greater than the related info in column G. I can manage that the information isn't matched up linearlly and will be including that in my formula once launching, but I'm stuck on the simple spot of getting the time types to match. IE, for row 10, column D of 7 min and 30 sec is greater than column G of 7 min, but because the times show up differently Excel won't recognize this. Can anybody help me get those times to be the same value type so the J10 formula will say "Too much TO"?

    Thank you!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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