You are searching about Excel Formula To Calculate Number Of Hours Between Two Dates, today we will share with you article about Excel Formula To Calculate Number Of Hours Between Two Dates was compiled and edited by our team from many sources on the internet. Hope this article on the topic Excel Formula To Calculate Number Of Hours Between Two Dates is useful to you.
Dealing With Conflict in the Workplace
Conflict is a major concern in both your personal and working life. If not dealt with quickly, tactfully and efficiently conflict could lead to serious confrontation and/or a complete breakdown of relationships. It could even lead to violent and dangerous situations.
A conflict could stem from a minor complaint that was not resolved and left to fester. This could then gradually grow into an insurmountable problem. A conflict can be as innocent as sibling rivalry – arguing over a toy – to a dispute with a customer or colleague over a product, service or procedure to a war between countries in extreme cases.
There will be times during the course of a working life where you will have to deal with complaints and conflicts. Your successful handling of these situations will have a direct bearing on you and your organisation’s reputation for customer service and its continued success.
What causes conflict.
Conflicts normally occur when people have different ideas and believe they have the superior view point. This is particularly true of conflict in the workplace – between colleagues and/or management. The issue becomes one of power, of gaining control or of ‘being proved right’. To resolve this type of conflict it is necessary to move from the power clash, to one of service and responsibility – to work for the good of the group rather than individuals within it. In resolving a conflict it should be more important to make sure that both parties needs are met rather than winning the argument.
Conflict can also be caused by a lack of communication or by a failure to recognise the needs of another person. Whatever the scenario, the main component in conflict is misunderstanding. These misunderstandings can occur due to differences in age, culture, race or religion. Conflict situations can include customer related issues, misunderstandings or communication barriers or Conflict among work colleagues.
Conflicts due to customer related issues.
A complaint, no matter how trivial it might sound to you, is legitimate in the eyes of the customer and must be taken seriously. Customers come into your organisation to do business. They have a need and they believe (or hope) that you will be able to fulfil that need. They are willing to pay you for your time, effort and service and they expect your full and undivided attention. If they do not receive this attention or a satisfactory product or service, then they are not receiving value for their money and then have every right to complain.
Conflicts arising out of customer related issues could include;
- problems or faults with services or products. The customer has not received the quality of service or product that they expected and are unhappy enough about it to complain. A complaint of this nature can be fairly easily resolved if the parties involved are prepared to communicate and compromise.
- delays or poor timing of product or service supply. The customer has been kept waiting longer than expected or advised for their product or service and, as in the point above, become upset at the delay. Delays can cause a great deal of inconvenience for customers, particularly if they have made time to be on hand and are then disappointed.
- difficult or demanding customers. Some customers are hard to please and are, by nature, very demanding and aggressive. If they are not handled carefully they could, potentially, become threatening.
- drug or alcohol related issues. These could include being refused entry or ejection from premises due to their condition and the risk they represent to other customers or staff.
Conflicts due to misunderstandings or communication barriers.
No two people are exactly alike – not even twins. People have different points of view brought about by the many influences on their lives.
These influences include;
genetics – the things that we inherit from our parents and over which we have no control. These things might involve the colour of our eyes and hair to our health.
upbringing – which involves the way in which our parents raised us and the values they instilled in us.
culture and religion – this influences the things that we believe to be true and the customs and traditions we follow
economics – our view on life can be strongly influenced by our economic situation, whether we are financially comfortable or struggling to make ends meet.
education – our level of education will also have a large impact on what we think and how we view the world.
the environment – this means the environment in which we operate: our neighbourhoods, housing situation, and the people we are surrounded by.
life experience – involves all the experiences we have had in our lives, the successes and failures, the lessons we have learned from these experiences and the many roles that we have played to date.
All of these things and more go in to making us the individuals we are and our thoughts and feelings about almost everything we come into contact with will be shaped by these influences. So we have our own opinions and points of view on a whole range of things and these sometimes clash with other peoples. These clashes can take the form of a lively but friendly debate but they could just as easily become heated and aggravated and degenerate into shouting matches. The beginnings of conflict.
We can avoid these situations by reaching an understanding between the parties. This can be done by communicating openly and honestly, being willing to listen to the other person’s point of view – remembering that the influences that have shaped their beliefs and view points could be very different to yours – but no less valid.
Misunderstandings and communication barriers could occur because;
- people do not listen to each other with an eye to reaching an understanding
- people are not prepared to compromise in order to resolve the situation
- people do not understand cultural differences and are not prepared to make allowances for them.
To resolve a conflict situation steps need to be taken to bring the two points of view closer – to reach a compromise that both parties can accept. Part of good conflict resolution skills is the art of communication and recognising the barriers to a good two way communications flow. These barriers can include;
- Not paying attention. Customers or colleagues who are trying to communicate with you will feel ignored and frustrated if you allow yourself to become distracted. Not paying attention to them is rude and unprofessional and stops the communication flow. The result of this could be the loss of a customer, a complaint about you to your manager or a loss of respect. Do not allow yourself to be distracted – focus your attention on what is being said and really listen to your customer or colleague. If you must interrupt the conversation to answer the phone, or speak with another staff member, excuse yourself.
- Not looking at a person. Maintaining reasonable eye contact with the person you are communicating with is very important. It shows you are paying attention and that you are interested. By not looking at the person who is talking to you, you are indicating not only disinterest, but are also making them feel uncomfortable. They may think you are not being honest or trustworthy – you may be trying to hide something from them.
- Interrupting. Interrupting someone when they are talking is a major barrier to open, two way communication and could easily cause conflict. Once again, you are indicating that you are not interested in what they have to say. Breaking into what they are saying to make your own thoughts known, or worse, to finish their sentences for them is no way to gain a proper understanding of the other persons needs and expectations. Allow them to finish what they are saying and pay attention. If, for some reason, the conversation needs to be wound up, then take control by asking leading or closing questions – that allow for short answers only.
- Tone of voice. The tone of voice used during a conversation could also start a conflict. Arrogance, demand, anger, whining, disinterest etc all add a tone to the voice that can cause people to react negatively. When dealing with customers or colleagues you should keep your tone friendly, calm and pleasant. At the very least, if you do feel annoyed you should try and keep the tone of your voice neutral.
- Sarcasm. Sarcasm has no place in any conversation between two people and is an open invitation for conflict. There are times, in everyone’s working life, when you think “If I get asked one more stupid question, I’ll go mad!”, but sarcasm in the face of a silly question or remark does nothing but hurt the other person and, possibly, dent their self esteem. We often forget that not everyone knows everything we do about our industry – in fact most customers know very little about the tourism and hospitality industries. We can forgive our customers or junior colleagues, therefore, for asking questions that may have obvious answers – obvious only to someone who knows. Show patience and understanding – it’s just as easy and much more pleasant than giving a sarcastic or snide answer.
- Rudeness. There is never any excuse for rudeness. A respectful and courteous attitude on your part should avoid or defuse any antagonism a person brings with them into your office. Should you find yourself never the less, dealing with a person with whom you simply cannot get along – rudeness is not the solution. Speak to your supervisor or manager and ask for their advice.
- Cultural differences. Cultural differences can be the source of a great many conflicts. When dealing with people from other countries, other beliefs and so on, it is easy to misunderstand words, gestures and customs. If you want to excel at your profession it is a good idea to familiarise yourself with some of the more prevalent customs of other cultures. On the whole, however, people from all over the world, from all walks of life and from all creeds respond well to respectful and courteous behaviour. Do not make fun of customs you don’t understand. Treat everyone you deal with, both customers and colleagues, with respect and you should do very well.
Any one of these points could provoke a customer or a colleague into complaining – which could then, potentially, turn into a conflict. It is a good idea therefore, to remain courteous and polite when dealing with other people.
Signs of potential conflict
A conflict does not happen suddenly. People do not go from calm and cool one moment to angry and aggressive the next.
Conflict builds. It may take hours, weeks or even years. However long the process takes, there are always signs that a conflict is building. If these signs are recognised early then steps can be taken to quickly and efficiently resolve the situation before it becomes a major issue.
Early signs of conflict can include (but are not limited to):
- aggressive body language: Narrowed eyes – trying to intimidate you Flared nostrils – a sure sign of building anger as the person takes a deep breath, either to control themselves or to go on the attack Stretched muscles in the face and jaw line – tightened in building anger and aggression Tapping fingers or feet – shows impatience
- malicious or negative gossip among colleagues
- difficulty in discussing an issue calmly and rationally
- tone of voice – indicating boredom, sarcasm, irritation
These are all signs of irritation, dissatisfaction or impatience. If you recognise any of these signs when dealing with a complaint or a conflict you should endeavour to find out the reasons why the other person is starting to feel impatient or irritated. You can do this by asking relevant questions and listening carefully to their answers. In this way you can reach an understanding of the issue at hand and perhaps avoid escalating the situation.
If not recognised and acted upon these signs could then be followed by;
- Raised voice – speaking rapidly in a loud, high pitched voice – or even shouting
- Body leaning forward in an effort to intimidate
- Hand gestures – finger poking and pointing in an aggressive manner.
- Refusal to cooperate
- Storming out of a room, slamming doors, drawers or implements
At this point you may already have a conflict and it will take careful handling to bring the situation back under control
Complaints can escalate into conflict and conflict, if not resolved effectively, could potentially escalate into a crisis.
People wish to be taken seriously. If they are not, or are repeatedly ignored, can become aggressive and a threat to safety and security of the organisation and the people in it. Equally, people who are under the influence of drugs or alcohol, and are not in control of themselves, can present a danger to those around them if they are not handled carefully.
Situations where personal safety of customers or colleagues may be threatened and assistance required may involve:
- drug or alcohol affected persons
- people with guns or other weapons
- situations where someone has been or may be hurt
- people who appear to be violent or threatening
- situations where customers refuse to leave or to be pacified.
In these cases it is extremely important to:
- remain calm yourself and to try and calm the other person.
- move them, discreetly, out of the main area of your office or shop
- take note of details of the problem for future reference
- DO NOT argue with a person who is visibly upset or aggressive as this will only compound the situation.
- bring in the assistance of relevant management, security and/or authorities such as police as soon as possible.
You cannot simply make a conflict go away by giving the complaining party whatever they want. Resolving a conflict is a delicate balance between reaching an agreement between parties while at the same time staying within the constraints of your organisations requirements and policies.
These constraints may include:
Costs issues. Often, a conflict with a customer will be centred around dissatisfaction with a product or service. If the product or service was actually found to be faulty then the simplest solution to the problem is a straight forward replacement. Sometimes, however, the situation is not as simple and the customer will demand further compensation. In these cases a replacement may not be enough and something extra may need to be done. When determining the extent of compensation, if any, to be offered to the client, there are a few issues to consider. These could include;
- Customer good will & repeat business. If your organisation is dependent on customers coming back again then this is an important consideration.
- Organisations reputation. A dissatisfied customer will tell many people that they received bad service from an organisation who did not meet their needs and this can lead to a loss of business.
- Direct cost. Compensation to a client can be in the form of cash, additional products or services, or an upgrade to the product or service they have purchased. If compensation is to be of a monetary nature then the cost to the organisation must be considered.
Organisation policy on refunds or exchange. Most organisations will have policies on giving refunds. Some companies will give money back, others will give credit for products or services they provide. In the tourism industry you must also consider the refund policies of the principals you deal with. For example some advance purchase airline tickets do not allow refunds at all within a given period prior to departure and if the customer does not use the ticket, they have lost their money.
So before agreeing to provide a solution to the customer, you must first determine if it is financially viable to do so and to take the organisations policies and procedures into account.
Resolving conflict situations
When a person has purchased a product or service from your organisation and it is not what they expected it to be, or does not perform properly they will feel dissatisfied and disappointed. As a consequence when this person complains they generally believe that they have a legitimate reason for doing so and they may do so long and heatedly to the first person they come across in your organisation. This might be you – even though you had nothing to do with the original sale and have never met the customer. The worst thing you can do is tell them its not your problem.
Take ownership of the issue, regardless of whether you were involved in the problem or not. “Passing the buck” at this point is not going to help matters. The customer approached YOU, so deal with the issue and don’t pass them off saying “It’s not my problem” or “The lady who handled this is not here now….”. At that particular moment in time the customer does not see you, the individual, they see you, the representative of the company, so it is you, the representative of the company, they expect to help them.
If you were not part of the original transaction where the problem occurred get as much information as you can from the customer to help you determine what to do. For example, you could ask;
- exactly what the problem is
- when & where it occurred
- how long ago the problem occurred
- what they paid for the product or service
- how they see the situation being resolved – this will give you an idea of the person’s expectations and how they impact on the organisation’s policies and procedures.
If the person who was involved in the original transaction is available you should ask them to join the discussion in order to get both sides of the picture. It is very important, however, to keep to the issue at hand and not to let emotions or ego get in the way of finding a solution to the problem; stay calm, listen to all points of view with an open mind and try to keep the communications process flowing in a positive manner.
Finding a solution to a conflict involves a certain set of skills and techniques. It takes a step by step approach to ensure a positive outcome for all parties concerned.
Steps in resolving conflict
Finding a solution to a conflict will often become a matter of “give and take” where one party makes a suggestion that may not be entirely acceptable to the other. When this happens you will need to define the issues as seen by all parties and negotiate a mutually acceptable outcome. This would normally happen in a logical sequence:
- Define the problem
- Work out what you want out of the conflict
- Brainstorm for options
- Evaluate solutions
- Decide on solutions
Define the problem
Everyone involved in the conflict needs to agree on a definition of the problem before it can be solved. This could mean describing the problem in terms of each persons needs and understanding of the issue at hand. Questions to consider might include:
- What is the problem? Is it only my problem? Who else is involved?
- Can I solve it? Is it worth solving?
- Is this the real problem or merely a symptom of a larger one?
- Does it need an immediate solution or can it wait? Is it likely to go away by itself? Can I risk ignoring it?
- Does the problem have ethical dimensions?
- What conditions must the solution satisfy?
- Will the solution affect something that must remain unchanged?
- Will I need help?
Asking these types of questions will outline what all the issues are from various perspectives giving you a firm foundation for exploring options. Depending on the nature of the problem and what it will take to resolve it, it might in extreme cases even be worth letting the matter go. It is important to keep a customer satisfied, but not at all costs. If a customer is being completely unreasonable and demanding then sometimes it is the better option to lose that customer.
Work out what you want out of the conflict
You also need to develop a clear understanding of the expected outcome. This could be; an agreement on acceptable compensation for faulty products or service a better relationship with the other party a mutually acceptable solution to an ongoing work issue the other person to respect your opinion With firm expectations of what would be an acceptable outcome in mind, you can then begin to negotiate with the other party until an agreement has been reached.
Brainstorm for options – When all parties concerned have had the opportunity to explain their feelings on the matter, then all of the issues should be out in the open. At this point you can look at the various options available. There might be a number of solutions to the problem which could work for everyone involved. Don’t get stuck on one solution just because it’s the first one you find. Be creative about the possibilities available to you, and look for common ground. You can decide from the options later.
Evaluate solutions – In deciding the best result from the options available you should weigh up the pros and cons of each one based on the organisations policies and procedures, cost or budgetary constraints, legal ramifications and mutual benefit. When discussing and evaluating options it is often the case that each party will prefer an option that most closely gives them what they want regardless of its impact on the other party. In these cases you need to negotiate and compromise so that an agreement that both parties are satisfied with can be reached.
The Art of Compromise – Compromise does not mean giving in or losing. It means looking for ways to meet each others needs by making concessions to the other party involved. Compromise involves negotiating what you are, or are not, prepared to do in order to get what you want.
You should be open to good arguments rather than pressure or manipulation from the other party. Be open to reason but closed to threats. In difficult conflicts it might be necessary to bring in another person to mediate. This person might need to be skilled, mutually respected, and not have a personal interest in the outcome.
Decide on a mutually acceptable solution – When all available options have been tabled and considered then you can decide on the best one – the one that keeps both parties happy! Make sure each person takes responsibility for agreeing with the decision. This may take the form of a written agreement or contract, or a letter outlining what was agreed to.
Separate your feelings from the problem. When your emotions get tangled up in the pros and cons of an argument you can’t reach the best conclusion. If you take a strong position because of the way you feel, you can’t work out the best solution to the problem because your perception of it is controlled by things which are likely to have nothing to do with the problem. It’s not about who is right or wrong. Arguing over whose fault it is or placing blame will do nothing but increase tension and get in the way of resolving the situation. You should not let your feelings get in the way. Points that can help here include:
- Act and speak calmly. Arguing with a customer or colleague could result in a full blown confrontation. Pause before making a response to them. This will give you time to collect yourself, to calm any irritation you might feel and also gives you a chance to work out how to phrase your response in the most appropriate way.
- Try to put yourself in the other person’s place; empathise with them. Use expressions such as “I can understand why you would feel that way” and encourage them to share their point of view.
- Listen carefully and completely to what they are saying. Hear them out without interrupting them. Show you are interested through a positive listening attitude and ask clarifying questions to make sure you have understood them correctly.
- Be patient and understanding. Don’t interrupt them. Once they have had their say, they will generally be a lot calmer and easier to reason with. The problem can then often be resolved in a civilised manner.
- At the appropriate time, acknowledge their point of view and ask them to give you the courtesy of now listening to your (organisation’s) position. For example; “I understand what you are saying, may I now explain our position to you, and then we can see how we could solve the problem together?”
Recording accurate information about complaints, conflicts and their outcomes is a very important part of any business. This type of information will show (among other things);
- areas of the business that are not working properly
- processes and procedures that need to be changed.
- things that customer like / or don’t like about your products or services
- gaps in the supply and demand of your products or services
With this information in hand, an organisation can then use it to continually improve its products, services, image and reputation.
Information can be recorded by way of (but not limited to):
- Letters (or emails)of complaint. These should always be taken seriously. A written complaint should be answered immediately – even if it is simply to advise the customer what will happen next. An investigation of the complaint should follow and the customer should then be advised of the outcome. A report of the complaint and the outcome should then be sent to the relevant supervisor or manager for any further action needed.
- Notes taken during a phone call or after a face to face meeting. Once again, it is good business practice to record the details of complaints or discussions about conflicts. These notes can be used for the organisation’s continuous improvement programme but they can also be used as reminders of the conversation should a dispute arise.
- Formal documentation. These could be; Refund forms Credit notes Contracts or agreement forms
Evaluating conflict situations
It is good business practice to continually look for ways in which an organisation can improve its practices and procedures. One of the main ways an organisation can do this is by seeking feedback – comments from customers, staff and other visitors to the organisation. Reasons for seeking feedback can include;
- to ensure customer satisfaction and repeat business
- to maintain its reputation
- to learn from errors or mistakes
- to make improvements to the service or product delivery or quality to improve productivity and efficiency
- follow up to see if customer is satisfied in the case of a complaint or conflict
In a matter as important as a complaint or a conflict, feedback can also be sought by way of a phone call, letter or perhaps even a personal visit the person concerned to ensure that any issue that existed between the conflicting parties has been successfully resolved.
When looking for how effective the solution to a conflict was, some of the questions that should be asked could include:
Why did this situation happen in the first place? A close examination of the circumstances surrounding the matter of conflict from both the customers and the organisations perspective can show up problems in procedure, policy or product or service delivery. Issues to look at could include;
- Was there a breakdown in communication?
- Is the service delivery as good as it could be?
- Are the organisation’s policies and procedures as effective as they could be?
- Was the service/product faulty in some way?
Did we resolve it effectively? This is a very important question from the customers and the organisations point of view.
- For the customer, resolving the problem effectively could mean that they are satisfied, that they have received value for their money and most importantly that they will probably continue to do business with you.
- For the organisation, resolving the problem effectively could mean that they have retained a customer and kept within organisational guidelines and budgets
When looking at how the problem was resolved:
- Ask critical questions about the outcome – was it the best possible option for every one concerned? Did it cost your organisation money? Too much money? Was the outcome worth the cost?
- Evaluate the customer’s reaction to your proposal – were they happy with it? Were they prepared to be reasonable? Will they continue to do business with you?
- Compare the situation to any previous incidents of this nature. How was it handled last time? Is there a pattern emerging that should be addressed?
- What can we do to prevent it happening in the future? By looking at how the problem occurred in the first place and how effectively you resolved it you can then take any necessary steps to prevent the same thing happening again. This might mean; A change in policy or procedure A change in a product or service Training staff in customer service skills Training staff in conflict and complaint handling
By asking these, and other relevant questions, you can make improvements to the organisation. This could lead to greater customer and staff satisfaction which will have a positive impact on the organisations continued success and prosperity.
For more information go to: www.lptraining.com.au
Video about Excel Formula To Calculate Number Of Hours Between Two Dates
You can see more content about Excel Formula To Calculate Number Of Hours Between Two Dates on our youtube channel: Click Here
Question about Excel Formula To Calculate Number Of Hours Between Two Dates
If you have any questions about Excel Formula To Calculate Number Of Hours Between Two Dates, please let us know, all your questions or suggestions will help us improve in the following articles!
The article Excel Formula To Calculate Number Of Hours Between Two Dates was compiled by me and my team from many sources. If you find the article Excel Formula To Calculate Number Of Hours Between Two Dates helpful to you, please support the team Like or Share!
Rate Articles Excel Formula To Calculate Number Of Hours Between Two Dates
Rate: 4-5 stars
Views: 2583129 6
Search keywords Excel Formula To Calculate Number Of Hours Between Two Dates
Excel Formula To Calculate Number Of Hours Between Two Dates
way Excel Formula To Calculate Number Of Hours Between Two Dates
tutorial Excel Formula To Calculate Number Of Hours Between Two Dates
Excel Formula To Calculate Number Of Hours Between Two Dates free
#Dealing #Conflict #Workplace