i have a spreadsheet that has date and time info pasted into it..

from this i calculate difference and make sure the lowest date is subtracted from the highest date..

this number is converted to a time value and then i do stuff with it from there..

the cells with the dates are formatted as custom m/d/yyyy h:mm

usually looking like this

B3..............C3
9/3/2008 14:19..10/27/2008 17:03

my formula to calc the dates is this =MAX(B3:C3)-MIN(B3:C3)

normally it works.. however i have found a few dates that wont calculate namely

22/10/2008 13:23:04 23/10/2008 15:26:36


what the f*** is going on and why wont this fgt program calc my dates

Those dates you say aren't working aren't in the same custom format you described, have you checked that they haven't been pasted as text?

ok i found the solution.. the gayed up data is recording in 2 formats.. so when it comes into excel it dont work

some dates are dd/mm/yy and others are mm/dd/yy