=if(or(g14=0,h14=0),"",(IF(G14<TIME(7,0,0),TIME(7, 0,0)-G14,0))+(IF(H14TIME(19,0,0),H14-TIME(19,0,0),0)))

sonar < wrote:

Hi, I am using this formula, but everytime I have no hours in my start
and finish cells, or if its 00:00, it gives me a 7.00, how can I make
this not do that. But instead make it a 0.00 rather, as I dont want my
total of all the nightshift hours to show an amount if its not suppost
to exist.

=(IF(G14<TIME(7,0,0),TIME(7,0,0)-G14,0))+(IF(H14TIME(19,0,0),H14-TIME(19,0,0),0))

Thanks


---
Message posted from http://www.ExcelForum.com/