The earlier was merely a link formula. It presumes that your formula
computing the 8 hours is in '2 Wk Schedule'!B8.

If that formula in '2 Wk Schedule'!B8 could also be returning a zero besides
a blank: "" or an error value, then think you could try:
=IF(ISERROR('2 Wk Schedule'!B8),"",IF(OR('2 Wk Schedule'!B8="",'2 Wk
Schedule'!B8=0),"",'2 Wk Schedule'!B8))

A zero will display as "12:00 am" when formatted as time
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"charlyx5" wrote:

Max

That did not work
this is what I entered
=IF(ISERROR('2 Wk Schedule'!B8),"",IF('2 Wk Schedule'!B8="","",'2 Wk
Schedule'!B8))

Result 12:00 am
instead of 8.00