Ok try to format cell with datetime, apply some diff datetime format, share the result. Place two date values in two different cells, get the difference in 3rd cell. If you still wont find the bugs and difference between ms and open , i will upload a excel sheet with data, try same data on open office.