Posted 10 June 2012 - 04:05
the laptop that my company has issued me comes with excel 2003 because of compatible issues with legacy systems that company is using.
however, i have realized my excel is the only one around not able to subtract date & time from date & time.
i've change the format of cells to number and did everything the same. except that mine shows #value while my colleagues computer/laptop shows e.g 0.31 (days)
i use the basic =E3-C3 kind of formula and it has worked on other laptops/computers before. just not on this one. something in the settings not set right?
the tech guy have not updated the windows xp (@SP3 but says windows update agent is not compatible to get anymore updates) and i cannot update it manually because of locked administrator rights.