You'll see #####'s in a cell if you try to show negative times (or dates) and
you're not using 1904 as your base date.

Maybe you can adjust the formula:

=if(a$2b$2,0,b$2-$a2)



Kim Shelton at PDC wrote:

I have a chart setup to calculate the converted time between to time frames
example. The crew started at 7:00am and ended at 10:00 am. Everything works
except with the time is started at 7:15 am and ended at 7:00 am which of
course is not possible but because it is a continuous chart I have it setup
that way. I want the answer to be 0:00 instead of the ##### symbols error
that it gives me. See sample below. My chart continues until 10:00 pm on
the end of and out.
IN 7:00 AM 7:15 AM 7:30 AM 7:45 AM
OUT
7:00 AM 0:00 ##### ##### #####
7:15 AM 0:15 ##### ##### #####
7:30 AM 0:30 0:15 0:00 #####
7:45 AM 0:45 0:30 0:15 0:00
8:00 AM 1:00 0:45 0:30 0:15

--

Dave Peterson