- 0
Excel 2003 calculate difference between date and time giving #value
Asked by
dpanda,
-
Recently Browsing 0 members
- No registered users viewing this page.
-
Posts
-
By daryld · Posted
I think you will find it has been well documented across multiple media platforms the many reasons for the fall of destiny which supports the reasons i give above, my opinion is that is what caused the most damage to the company as they stopped being a gaming company and pushed a political narrative, look how damaging the dei road was for bud light, stocks crashed multiple resignations and job losses over a box ticking exercise, when decisions are made not to better something but to instead box tick and deliver something that the vast majority didnt ask for then you will get kick back and it normally has a massive financial impact -
.thumb.png.b7089ebbdf00d96b3b92dddbd04bac02.png)
By PsYcHoKiLLa · Posted
Give Elon Musk, who illegally had access to citizen's data, even more of your data ! Top idea ! -
By PsYcHoKiLLa · Posted
An oldie but a goodie, we used to punish people in the office who didn't lock their computers, by either doing the above or changing their desktop wallpaper to a reclining David Hasselhoff -
-
By WiltshireHam · Posted
I did that to a work colleague many years ago when he left it logged in. Unfortunately I was out of the office the next day, and even the IT department was stumped lol. Got a bit of a bollocking when I got back into the office, but, by god, it was worth it.
-
-
Recent Achievements
-
xvvxcvv earned a badge
Week One Done
-
xvvxcvv earned a badge
One Month Later
-
Xonos went up a rank
Enthusiast
-
Admir earned a badge
Conversation Starter
-
The_Focal_Point earned a badge
First Post
-
-
Popular Contributors
-
Tell a friend
.thumb.png.b7089ebbdf00d96b3b92dddbd04bac02.png)
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
https://www.neowin.net/forum/topic/1083151-excel-2003-calculate-difference-between-date-and-time-giving-value/Share on other sites
4 answers to this question
Recommended Posts