Are you subtracting times to get that result? Excel by default will not display negative times and puts in #####
There are two ways around this:
a) Use a formula like =MOD(A1-B1,1) which will display a positive time even if B1 is greater than A1.
b) In Tools > Options, switch to the 1904 date system.