My client sends me an automated spreadsheet with one column being date and time a ticket is created. The date is listed as Australians would do it (ie day before month) but excel does not recognize it as a date. So when I try to extract just the month or day, or to sort, it doesn't work.
If I try to format it as a date, if the day is less than 12 excel makes that the month, the rest it ignores. Even if I format it as Australian dates, excel switches them aroundHow do I tell excel this is a date written in Australian format and I do not want it changed.2 AnswersSoftware4 months ago
- 3 AnswersPolitics2 years ago
After a week in which it was established that David Warner is a bit of a goose sometimes (hardly breaking news), but also that the South African team are a bunch of cry baby hypocrites and Quinton de Kock is a liar, it would seem the South African response is to engage in a national day of ****-shaming against Warner's wife while still demanding that they hold the moral high ground?Cricket2 years ago
The emails are addressed to people we have met but have only a passing acquaintance with. Do we use their first name or a title (eg Mr) and their last name?
For instance in sending an email to Haider al-Abadi should I use
Mr Abadi2 AnswersUnited Arab Emirates3 years ago
Were Scaramuccia not such a political and intellectual lightweight (well and truly living up to his namesake, the boastful clown of Italian theatre) his threat to use the Justice Department to harass a reporter for legally publishing publicly available material would surely be considered one of the greatest attacks on the first Amendment to ever come from the White House?6 AnswersPolitics3 years ago
Why are Republicans in the House and Senate having such trouble coming up with healthcare legislation?
Shouldn't they just vote on Trump's plan that will cover everyone?
Or was the Donald lying again?9 AnswersPolitics3 years ago
- 4 AnswersPolitics4 years ago
It seems inevitable that Trump will have the most candidates at the conclusion of the Primaries. It also seems likely that he will fall short of the 1237 he needs to avoid a brokered convention. If he fails to get Florida's 99 winner takes all delegates then a brokered convention seems inevitable. Since Cruz and Kasich have no hope of winning Florida surely they would be better off withdrawing and leaving Rubio with a chance of taking those delegates. That would then leave Trump short of the majority of delegates and leave the possibility open for any of the candidates to still win the nomination.2 AnswersPolitics4 years ago
I noticed that Hartley was captain yesterday against Scotland. Hartley is probably the dirtiest player in the game. He is a thug, a cheat and a coward. He brings the game into disrepute merely by playing it. A man who has collectively served more than a year of suspensions in his professional career clearly holds the game in contempt. By naming him captain England are giving up any right to complain about foul play - after all they are demonstrating that foul play is something they believe should be rewarded. If England have nobody better to give the captaincy to than this disgrace of a man, who isn't even English, what does that say about the sorry state of English rugby?2 AnswersRugby5 years ago
Well Jade Helm is over and we managed to stop the government declaring martial law and taking all dissenters off to FEMA camps.?
Everyone called us crazy conspiracy theorists, but thanks to the attention we brought to Obama's plans they had to stand down and not arrest us all and take our guns. Do you think the American people will thank us? And how do we make certain that next time the government wants to try this we all stay vigilant?6 AnswersPolitics5 years ago
A guy who has never had any role in GOP politics suddenly comes out with absurd right wing talking points but not a single workable policy solution, and he is not only leading in the polls but also controlling the debates and really dictating the whole agenda of the GOP nomination battle? And more to the point moving it all away from reality - yet a quarter of GOP voters are enamored with this guy who's past proposals have included a wealth tax, increasing the corporate tax rate to pay for a single payer health system, and introducing more gun control. What gives?4 AnswersPolitics5 years ago
I have an excel problem. I have the schedules of people but need to convert them to a very specific format for a CSV to upload to payroll.?
So in one column I have start time, and in another I have end time. These are entered at present as text in the format 8:00 AM.
So I need to take the start time and end time from two different columns and merge them into one 8 digit number. For example start time is 8:00 AM and finish time is 4:00 PM I need it to say 080016001 AnswerSoftware5 years ago
a. "To continue the significant progress we have made in cleaning up the environment, I recommend a $153 million increase for the Environmental Protection Agency’s regulatory, research and enforcement program."
b. "Because changes in the earth’s natural systems can have tremendous economic and social effects, global climate change is becoming a critical concern."
c. "It is mankind and his activities that are changing the environment of our planet in damaging and dangerous ways."
d. "we do agree our country must take action to address climate change."
e.“my best assessment of the data is that the world is getting warmer, that human activity contributes to that warming, and that policymakers should therefore consider the risk of negative consequences.”5 AnswersPolitics6 years ago
A White House source has leaked the content of Obama's planned Executive Order on immigration.
Obama will announce the executive order that simply directs the Attorney General to "take any steps necessary to defer the enforced departure.." of approximate 30% of the illegal immigrants in the USA for 4 years. It goes on to require the State Department to waive the requirement for these people to have a valid passport and to allow them to legally work in the USA.
In announcing the Executive Order the President will actually demand amnesty with the words "I believe in the idea of amnesty for those who have put down roots and lived here, even though sometime back they may have entered illegally" .
Surely instructing the AG and SoS to simply disregard the law of the land and allow criminals to get away with their criminal acts is an impeachable offense?16 AnswersPolitics6 years ago
Will there be a delayed telecast of Pacquiao Bradley on Manila free to air tv on Sunday? What channel and what?
time? I cannot find it on the TV listings.2 AnswersPhilippines6 years ago
I have been looking everywhere but there is no website for the Makati Coliseum, Phil Boxing do not offer any information, and SM tickets and Ticketnet do not even seem to be aware of it2 AnswersBoxing7 years ago
I have been looking everywhere but there is no website for the Makati Coliseum, Phil Boxing do not offer any information, and SM tickets and Ticketnet do not even seem to be aware of it2 AnswersPhilippines7 years ago