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.
Question
dpanda
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.
Link to comment
Share on other sites
4 answers to this question
Recommended Posts