Date formula if positive show, if negative don't show.

**Fotis1991** · 03-13-2012, 09:19 AM

Hi

Give a try to this.

=IF(OR(VALUE(TEXT((NOW()-E16)/24,"[h]"))<0,(VALUE(TEXT((NOW()-E16)/24,"[h]"))="",""),VALUE(TEXT((NOW()-E16)/24,"[h]"))))

Hope to helps you.

**Cyberpawz** · 03-13-2012, 09:59 AM

Originally Posted by Fotis1991

Hi

Give a try to this.

=IF(OR(VALUE(TEXT((NOW()-E16)/24,"[h]"))<0,(VALUE(TEXT((NOW()-E16)/24,"[h]"))="",""),VALUE(TEXT((NOW()-E16)/24,"[h]"))))

Hope to helps you.

I come back with a window that says formula contains an error.