Ah, a simpler way, since you say
If F2 is blank, I want it to disregard the formula and display 0.

=IF(F2="",0,IF(C2D2,TEXT(F2-C2,"h:mm"),TEXT(F2-D2,"h:mm")))
Strap on a front IF to check on F2
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---