=VALUE(TEXT((NOW()-E16)/24,"[h]"))
This is the formula I'm using now, if I have a positive number I want it to show up, if the number is negative, I don't want it to show up. Is this possible?
=VALUE(TEXT((NOW()-E16)/24,"[h]"))
This is the formula I'm using now, if I have a positive number I want it to show up, if the number is negative, I don't want it to show up. Is this possible?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks