How to subtract date and time in excelงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
1.พัฒนานะบบ IOT ดึงข้อมูลจาก PLC แล้วนำมาแสดงผลในรูปแบบ Web Site โดยแสดงข้อมูลเป็น Real Time 2.สามารถใช้อุปกรณ์ของของบริษัท (Embedded PC) มี SIM ออก Internet ได้ หรือสามารถใช้อุปกรณ์ที่ผู้พัฒนาถนัด แต่ต้องเป็นอุปกรณ์ที่ทนต่อสภาพการใช้งานในโรงงานครับ (ความร้อนและฝุ่น) 3.สามารถใช้ Server ของบริษัทได้ สามารถเลือกได้ตามความถนัดแบบ Windows / Linux และ Database SQL , MySQL, MogoDB , InfluxDB เลือกได้ตามความถนัดครับ 4.เก็บข้อมูลไว้ดูย้อนหลังได้ 90 วัน
...Content ดังนี้ครับ 1. ให้พนักงานขาย รายงานรุ่นและจำนวนที่ขายกลับมาที่เรา โดยในเว็บจะมีสรุปยอดขายเป็นกราฟหรือชาร์ตต่างๆให้ ที่สามารถ sort เป็น สาขา เป็นเขต หรือทั้งประเทศได้ แบ้วแต่แกนที่เราต้องการ 2. มีระบบ Log in ซึ่งจะยึด user ของพนักงานกับสาขาที่เรากำหนดไว้ หมายความว่าเมื่อพนักงานกดรายงานยอดขายระบบจะ แท็กว่ามาจากสาขาไหน 3. หน้าพื้นฐาน เพื่อแจ้งข่าวสารหรือโปรโมชั่นต่างๆ และสามารถแก้ไขได้ง่าย 4. มีแพลตฟอร์มหลังบ้านที่สามารถแก้ไข เพิ่ม ลบ ข้อมูลได้ ทั้งในเรื่องของข้อมูลพนักงานข้อมูลสาขา โดยกำหนดให้ทำได้เฉพาะ User ที่กำหนดไว้ 5. สามารถ Export ข้อมูล รายงานต่างๆมาเป็น Excel 6. สามารถทำข้อสอบในลักษณะคล้ายๆ Google form 11:20 Avatar ได้ครับ 11:20 Avatar มี host หรือยังครับ 12:05 ยังครับ อยากทราบราคาก่อนนะครับ ว่าเริ่มต้นที่เท่าไหร่ 12:12 Avatar คร่าวๆ ประมาณ 1...
ทำ excel คำนวนภาษีส่วนบุคคล 5 คน โดยสามารถเปลี่ยน variable ต่างต่างได้เพื่อทำ scenario analysis (ie ถ้ารายได้ x จะได้ x) ______________________________________________ Excel personal tax calculations for 5 people, with different variables changing for scenario analysis. (ie if income x is obtained x)
รูปแบบการทำงาน : 1.เข้าเก็บข้อมูลขั้นตอนการทำงานแต่ละแผนกที่บริษัท (เก็บครบตามหัวข้อที่ได้รับไม่ต้องเข้าออฟฟิตแล้วในช่วงนั้น) 2.พิมพ์สรุปข้อมูลทั้งภาษาไทย ตาม Template ที่กำหนดและรวมเล่ม (ทางอีเมล์) 3. ปรับแก้ไขงานบางส่วนและ ปริ้นท์รูปเล่ม (ส่งงานทางอีเมล์) ระยะเวลาเริ่มงาน เดือนสิงหาคม-กลางเดือนตุลาคม สถานที่ รถไฟฟ้ากรุงธนบุรี (เริ่มงาน 9 โมงเช้า- 5 .30 โมงเย็น) สามารถคุยเรื่องเวลาที่สะดวกและงานที่สามารถรับได้โดยไม่กระทบต่อการเรียนหรือ อื่น ๆ ได้ รายได้ ตามแผนกที่ได้รับมอบหมาย จำนวนงานไม่เท่ากัน ประมาณ 10000-12000 บาท / เดือน หากใครได้ภาษาอังกฤษ มีราคาอีกเรทนึง สามารถตกลงกันได้ ติดต่อ เบอร์ 0927498979 กี้
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
...seeking a professional to assist me with daily tasks on my website, which integrates with my work. The ideal candidate should be able to work in the following areas: - Data Entry: This involves entering specific data into the website's database and ensuring that all entries are accurate and up to date. - Customer Support: Providing timely and helpful responses to any customer inquiries or issues that may arise on the website. - Content Creation: Generating engaging, informative content for the website to keep visitors interested and coming back for more. The purpose of the site is to assist me with my work, and I need someone who can provide this assistance on a daily basis. It's cruci...
...video editor to join my team for a FULL-TIME role. You will be responsible for editing daily motion graphics for YouTube videos. The ideal candidate should be proficient in Adobe After Effects. Here is an example of the type of work needed: - - - Desired skills and experience: - Proficient in Adobe After Effects - Experience editing videos for social media platforms - Strong understanding of video editing techniques - Creative mindset with the ability to incorporate basic motion graphics - A keen eye for detail and high-quality standards This role is a full-time position, and you will
...Python expert to help me create a new Python script for data analysis purposes. The primary goal of the script will be to analyze a dataset that I already possess. The script should be able to handle large amounts of data efficiently, allowing for insightful analysis and visualization. The key requirements include: - Writing new code from scratch - Prior experience in data analysis using Python - Proficiency in Python libraries such as Pandas, NumPy, and Matplotlib If you have a solid background in data analysis and Python, and are able to create efficient, clean, and well-documented code, I'd like to hear from you. Here are details- I have to create a simulation that will fin...
I'm seeking to secure funding for a multi-industry workers' accommodation project. The accommodation caters to construction, seasonal farm, wind farm, abattoir, and gold mine workers. For this, I need a professionally crafted project proposal and a corresponding financial model in Excel. Ideal freelancers for this project should possess: - Proven experience in drafting project proposals related to housing or accommodation - In-depth knowledge in the creation of financial models using Excel - A strong understanding of multi-industry accommodations - Great analytical and strategic thinking skills - Familiarity in the Construction, Agriculture, Energy, Food Processing, and Mining Indu...
...as inspiration, and create a drawing in your own style, a similar style like this, that is funny of the celebrity MARK ZUCKERBERG, and the name for this drawing will be MOORK ZUCKABORG use anything that comes to imagination to make fun of him and make a funny drawing. We really like the drawing of Elawn Moosk, but try a few different options. The winner will probably enter more than one drawing. The winner will not only win $250, but they will win the chance to work with our team full time. We hope to see some awesome hilarious entries for this contest and hope to work with a lot of you soon as we may crown more than one winner. Prize is GAURANTEED! Be creative, enter as many times as you can with somethin...
...seeking a skilled market researcher to provide a comprehensive analysis of the potential market for a school discovery platform in the UAE. Project Title: Comprehensive Market Research for School Discovery Platform in UAE Overview: Our startup operates a school directory platform specifically designed to assist UAE families in finding and comparing schooling options for their children. We are committed to providing innovative solutions that help parents navigate the complex educational landscape with ease. To enhance our platform's effectiveness and ensure it meets the diverse needs of all families, comprehensive market research is crucial. This research will help us gain detailed insights into our target audience, t...
...13 years of experience and a team of 25 in-house developers. Currently, we are looking to hire some freelancers because we are at full capacity and do not have sufficient resources to handle some of our work. We are seeking a long-term partnership and are willing to provide 20-30 hours of work per week. We welcome both experienced freelancers and those new to this platform who have significant prior experience, such as working in a company before starting their freelance career. This job post is open to all qualified candidates. Now, let's discuss the job requirements, which are urgently needed: We require an expert Laravel Developer who is well-versed in third-party APIs. The candidate must have...
...operates a school directory platform specifically designed to assist UAE families in finding and comparing schooling options for their children. We are committed to providing innovative solutions that help parents navigate the complex educational landscape with ease. To enhance our platform's effectiveness and ensure it meets the diverse needs of all families, comprehensive market research is crucial. This research will help us gain detailed insights into our target audience, the broader industry landscape, and our competitive positioning. Scope of Work: Market Statistics: Collect up-to-date statistics on the UAE education sector, including details on student enrollments, enrollment trends, and the diversity o...
We are in need of a talented designer to create a poster for an upcoming concert we are hosting in Brussels on 26/10/24. The theme of the concert revolves around bagpipes and French horn, and so it's crucial that the design captures the essence of these two different instruments. There will be two bands at this event: "Les Echos de Ciergnon" (French Horn): "The Blue Stones Pipes and Drums"(Bagpipes): WARNING: make sure you use the right instruments in your design !!! Key Information: - The poster should include the date and time of the concert, as well as the venue location. Please review the attached document: the poster should include the text provided. Key Elements: - The design should ...
Innovation Company Product Manager seeks VBA developer for Excel app development Your resources • Windows 10/11 & MS Office (sorry MS Office MacOS has too many compatibility problems!) • Location with good acoustics, headphones, good internet (so we can have high quality meetings). ESSENTIAL - DO NOT IGNORE THIS! Your skills • Experienced with Excel and Excel VBA coding to professional standards • Good conversational Technical English • Touch typing (we do live meeting notes) • Python OO coding experience would be good Your Technical Knowledge and experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards inclu...
I'm looking for assistance with online data entry to Excel. The task is not overly complex but will involve working with reference numbers and ensuring accurate data entry and cross-referencing. Full training will be given and I will explain all. Budget is hourly and $3 max need to have good understanding of English
...skilled and creative professional who can help me in editing my PowerPoint presentations and a video that I've compiled. The aim is to give them an up-to-date, corporate and professional look for the purpose of our website launch. Key Points: - For the PowerPoint presentations, I need someone who can help in redesigning slides. This involves the use of infographics and new age graphics to make the information visually appealing and easier to understand. There's a need to reduce text in the PPTs and replace it with infographics. Also, enhancing visuals would be a great addition. - There's also a need to edit the content for a professional tone. This means ensuri...
...Power BI professional to assist with creating interactive dashboards and generating data visualizations. The selected expert will be expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level of Power BI experience ...
I'm in need of a talented Figma designer who can craft a visually striking single page UI for my crypto project. Key Features: - Real-time market data: This is a crucial aspect of the design. It needs to be easily accessible and comprehensible to users. - Price charts and graphs: These should be clear, visually appealing, and easy to interpret. Style: - Modern: I envision the UI with a modern feel, so it appears up-to-date and in tune with current design trends. The ideal candidate for this job should have: - Proficiency in Figma: As this project involves Figma design, it's important that the designer is comfortable and skilled in working with this software. - Experien...
...is an Amazon marketing agency based in Reading, UK and Athens, Greece. We are bunch of Amazon sellers ourselves that got frustrated with the process of selling on Amazon, decided to provide our services so others will not face the same problems. Our team constitutes of marketing specialists, designers, photographers & consultants that are here to alleviate the complexities of selling on Amazon. Some of the world’s most popular consumer brands and innovative start-ups are our clients. About the role We are looking for a focused, driven Amazon Account Manager. The ideal candidate stays on top of Amazon’s marketing trends, has experience with Amazon listings (including flat file expertise), product research and Amazon software tool...
I am in need of a skilled frontend developer to build the interface for my customizable meal delivery website. The website is designed to cater to users who would like to customize their meal plans as they order. Key Functionalities: - Real-time order tracking: I'd like the website to have a feature that allows users to track their orders in real time. This feature is essential for providing a great user experience, ensuring customers are up to date on their orders and can anticipate delivery times. Skills and Experience: - Proficiency in frontend development: You should have prior experience in developing user-friendly and visually appealing websites. - Familiarity...
I have a 1-page Excel spreadsheet with 9 text columns that need to be merged. I'm looking for someone who can start this job immediately and has experience in Excel data manipulation and formatting. Please only bid if you can do this job immediately and I will award and give you the file.
I'm seeking an expert in Excel analytics. This project involves working with existing but undisclosed business data to help me understand and optimize the business's performance through indicators like KPIs. The freelancer's task encompasses: - The creation of robust dashboards that effectively communicate KPI outcomes. - The execution of classification analysis to differentiate key data points. - Clustering the data into discernable patterns to aid business decision making. Ideal skills for this job include Excel proficiency, data analytics experience, and an understanding of key business metrics such as KPIs, dashboards, classification, and clustering. A background in business data analysis and ...
I'm in need of a professional who is highly skilled in Excel for a project involving 4-color conditional formatting. The project will focus predominantly on numerical data. Here are the essentials: - Proficiency in Excel is crucial - Deep understanding of 4 color conditional formatting, specifically with numerical data - Experience with setting color-coding based on specific values I'm looking for an expert who can swiftly and accurately apply this formatting to a substantial amount of data. Thanks for considering bidding on this project.
...looking for a skilled developer to create a chatbot for my website. The primary function of this chatbot will be to provide real-time support to users as they navigate the site. Key Requirements: - Development of a chatbot specifically for a website platform - It should be able to provide real-time support to users - Integration with tools or databases if necessary (TBD) Ideal Candidates Should: - Have experience in developing chatbots, specifically for website platforms - Be able to implement real-time support functionalities - Possess the ability to integrate the chatbot with other tools or databases if needed This project will involve not just the technical development of the chatbot, but also its seaml...
I'm in need of a dynamic Android application that will enable users to virtually 'try on' clothing items using their device's camera. The app should be compatible with both Android smartphones and tablets, and its primary functionality should be a virtual fitting room. Key Features: - Device Compatibility: The app should be designed to work seamlessly with both Android smartphones and tablets, ensuring a broad range of users can enjoy the experience. - Virtual Fitting Room: The core element of this app is its ability to allow users to try on clothes virtually. This should be an engaging and realistic experience for the user, helping them to visualize how an item would look on them. - Real-T...
I have a joyous announcement to make and need the creativity of an experienced graphic designer. The design must revolve around baby-themed illustrations and should encompass a pastel color scheme to add to the cheerful atmosphere. The main specifics the design should feature include: * Baby-themed illustrations that are appealing yet subtle. * A suitable and captivating arrangement of pastel colors. Moreover, this announcement must feature the due date of the arrival of my new bundle of joy. An eye for detail and a knack for creative communication are must-have skills. Experience in designing baby announcements or similar projects will be highly preferred. Bring on your creativity and make this momentous period all t...
...highly skilled and experienced developer to create a Management Information System (MIS) for my supply chain operations. Critical features should include: - Order Tracking: The system should provide up-to-date information on order status and delivery dates. - Supplier Management: The software should keep track of supplier-related data including payment information. For the inventory management component, the following capabilities are imperative: - Real-Time Tracking: The system should provide instantaneous updates for inventory data. - Low Stock Alerts: The ability for the system to alert when inventory runs low is crucial. - Sales Forecasting: Incorporation of a sales forecasting tool based on inventory output and sales hi...
I HAVE A WORD DOCUMENT THAT FEEDS VIA AN EXCEL SHEET VIA A COMPLEX VBA .. I need the following to addede: Split of Clients for Buys, Sells, Buy/Sell Spreads, Brokerage, Management Costs Currently, the Excel only allows the input of trades for one client, however, we’d like to have this broken up to at least 3 clients (I remarked client and partner in the meeting, however, we have some clients who have an account each, plus a joint-account).
...BELOW CAREFULLY AND CONTACT US FIRST IF YOU HAVE QUESTIONS* Details of our current project STACK can be seen here -> PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. We will start with 5-10 small task in and then go to some smaller .NET tasks all with 1 day sprints for you to become familiar with the software and then our main goal will be to integrate another B2B API for our MVNO. Initially we need part of the hours to be worked in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) later you can work on your time zone. If you are awarded the task we expect you to accept IMMEDIATE...
...platforms to compare their offerings and pricing structures. The goal is to provide a comprehensive, visually appealing summary that highlights key features, subscription plans, and costs associated with each software. Scope: Competitors: The platforms to be analyzed include Saninet 3D Planner, MATICAD DOMUS3D, PALETTE CAD, TILE LOOK, VISOFT, and SPARK VISION. Data Collection: Extract detailed information from the competitors' websites, focusing on: Price Features Customer Support Compatibility Cost Type of Subscription What is included in each type of subscription 3D Modeling Costs: Gather information about the costs associated with 3D modeling for new products, including the data required for the modeling process. Requirements: ...
As we venture into the development of an online store for both Instagram and Facebook, we are looking to showcase our unique product - gift paper bags and gift packing wrappers. Key tasks include: 1. Developing an online shop for two social media platforms. 2. Creating engaging, sellable designs for our products. The ideal professional for this work should not only have experience in social media store development but should also be a credible product designer. They should understand up-to-date trends and be able to make design suggestions that will appeal to our consumers. Creativity, with a keen attention to details, and experience in design related to gift packaging is also a bonus.
I'm seeking a skilled freelancer to assist in collecting email addresses for an upcoming email marketing campaign. The ideal candidate will have experience and expertise in web scraping, particularly from social media profiles, professional networking sites, and company websites. Key Responsibilities: - Collect email addresses from social media profiles, professional networking sites, and company websites. - Ensure the collection is accurate and up-to-date. - Provide the email addresses in a well-organized manner, making it easy to integrate into our marketing campaign. Target Industries: The primary focus for this collection is media, video production, photo production, TV production, film production, ...
