Results 1 to 7 of 7

Hide Null Values

Threaded View

  1. #5
    Registered User
    Join Date
    04-23-2007
    Posts
    3
    It would be kind of complicated. In my workbook, I am dealing with data in time format, imported to cells as text. The reason for this is that the data I am importing is in time format ##:## but does not stop/restart at 24 but continues increasing. This is what I have been using:

    Column H1=0:00
    Column K2=SUM(J2-H22)
    Column M2=SUM(M2-J2)

    If K2 is null, I still get the #VALUE! error. I am trying to get blank if there is a null or negative.
    Last edited by Eddieduce; 04-23-2007 at 03:22 PM.

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