S
Simon
I am using the below formula to work out how many hours
over 5 hours a day I am doing, it will only display the
time if I Input times into cells C1 and F1.
=IF(AND(C1<>"",F1<>""),(G1-TIME(5,0,0)),"")
The formula will not display the value 0 if time = 5
hours. Does anyone know how to amend the formula to
display 0??
over 5 hours a day I am doing, it will only display the
time if I Input times into cells C1 and F1.
=IF(AND(C1<>"",F1<>""),(G1-TIME(5,0,0)),"")
The formula will not display the value 0 if time = 5
hours. Does anyone know how to amend the formula to
display 0??