Excel calculate hours between two times after midnight jobs

I require an Adobe Premiere proficient video editor to handle a 2-5 minute music video in a clean and simple style. The task must be completed within 24 hours, and I need to be delivered an editable Adobe Premiere version as the final work. As I have not specified any particular visual effects or transitions, use your professional judgement to best meet the clean and simple style preference. My budget falls between 35 to 50€. Ideal freelancers will have experience in music video editing and be able to operate swiftly and efficiently. The video is for a class project and I have the files as XML

--- ### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation **Description:** I need a custom Excel sheet to help me track jobs completed by my installers, including details about each job, such as dates, customer information, and payments. The sheet should be able to automatically calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs completed by each installer. - ...

I'm in need of a classic and traditional logo to enhance brand recognition for my company. The primary use of the logo will be on print materials and also online. I have a design that I would like incorporated. The name of the company is BPIV Development. I would like the logo to be simple and I'd like to see it with both the word "Development" and just "BPIV". I'd like a classic font such as Times.

- Implementation of a feature that toggles audio output between Speaker and earphone in a React Webview screen inside a React Native app - The feature should be user-friendly, enabling seamless switching between the two audio outputs Ideal Skills: - Proficiency in React Native and React - Experience with audio output handling in mobile applications - Understanding of Android audio controls and React Native Webview integration If you have the necessary skills and experience, please get in touch.

Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or criteria for mergi...

I am looking for an expert who can as...expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge ...

...tax-related queries or issues that may arise during the process. Provide guidance and support for the green card sponsorship process concerning tax requirements. Requirements: Licensed and certified accountant with expertise in both US and Canadian tax systems. Proven experience working with dual citizens and understanding the intricacies involved. Excellent knowledge of tax treaties and regulations between Canada and the USA. Ability to work efficiently under time constraints and meet deadlines. Strong communication skills to explain complex tax issues in an understandable manner. Preferred Qualifications: Previous experience assisting clients with green card sponsorships. Familiarity with the latest tax software and e-filing systems. A track record of successfully resolving t...

I'm looking for a talented video editor to assist in creating Instagram reels. The primary goal of these reels is to increase brand awareness. Key Requirements: - Editing Style: The editing style required is cinematic. - Video Duration: The reels should be between 15-30 seconds. The ideal candidate should have experience in social media video editing, particularly Instagram. You must be able to bring the brand to life in a visually appealing and engaging way, while maintaining a cinematic feel. Please include relevant samples or portfolio links in your bid.

I'm seeking the expertise of a seasoned digital marketing freelancer to enhance my agency's operations. One who's adept in ...marketing services including: - Search Engine Optimization (SEO) - Social Media Marketing - Content Marketing - Website Design and Development - PPC - Meta Ads - Google Ads - Market Research The crux of this collaboration pivots on the generation of leads and conversions. Furthermore, the successful applicant will concentrate their strategies towards the working professionals demographic aged between 26-50. I strongly encourage enthusiastic digital marketing professionals with a proven track record in the above areas to apply. Your ability to design and implement result-oriented strategies that effectively cater to our target audience is a...

We are seeking a professional translator to translate a non-fiction book (87 pages, approximately 13,758 words) from English to Brazilian Portuguese. The finished book size will be 5" x 0.2" x 8". The book's genre is New Thought, Happin...including chapters, headings, subheadings, and any captions or illustrations. Proofread the translated manuscript for any errors or inconsistencies. Qualifications: Native-level Brazilian Portuguese speaker and writer Extensive experience translating non-fiction books, preferably in the same genre Excellent command of English grammar and vocabulary Strong understanding of cultural differences between English and Brazilian cultures Ability to meet deadlines and work independently Proficiency in translation software (e.g., SDL T...

I'm looking for a skilled video editor who can help me create engaging review and how-to videos for products. Key Responsibilities: - Editing TikTok videos to be between 15 to 60 seconds long - Incorporating English voice-over. I will provide sample videos for you to use in the video. You can use snippets of the sample videos and cut them in small snippets for the final video. I will provide the script at well.

I have a scientific article in French that I would like translated into English for publication in an English journal. The subject matter is in the field of geography so a background in this area would be beneficial. Key Requirements: - Fluency in both French and English - Experience with scientific translation - Understanding of geographical terminology The document is between 10 to 20 pages long and contains specialized terminology that needs to be translated accurately. If you are bilingual and have experience in this area, I would love to hear from you.

As a growing architectural firm, we are seeking an experienced Revit designer to develop medium-scale models for various types of buildings - residential, com...design to construction documentation - Coordinate with our on-site team to ensure accuracy of the model Required Skills: - Proficiency in various types of Revit modeling - Prior experience in residential, commercial, and industrial projects - Detailed understanding of various construction phases - Ability to handle medium-scale projects independently. Your expertise will help us bridge the gap between conception and construction, providing a more realistic and manageable understanding of each project. Candidates who can demonstrate a portfolio with a variety of building models aligning with our requirements will have an ...

...AI assistant with a focus on language understanding and real-time conversation support. Key Features: - Cross-Platform: The app should be developed for both iOS and Android, ensuring a wide user base. - Page Translation: Users should be able to translate live any page on their phone. - AI Assistant: The AI assistant should have the ability to provide information on various topics and should excel in language understanding, helping users with translation in real-time conversations with others. - Live Translation: The app should provide a smooth live translation experience for conversations. Ideal Skills: - Proficiency in React Native for cross-platform development. - Experience in building apps with live translation capabilities. - Strong background in AI development, specifi...

**Position: Native Spanish Translator*...formats, ensuring that the layout and formatting are preserved. - Edit and format Word documents to meet specific client requirements. - Ensure translated documents meet the quality standards and timelines set by clients. **Requirements:** - Must be a native speaker of Spanish with an excellent command of English. - Proven expertise in translation with a strong understanding of linguistic nuances between Spanish and English. - Proficient in converting PDF documents into editable Word formats. - Experience in formatting and editing Word documents with attention to detail. - Ability to work independently and deliver high-quality work under tight deadlines. - Willingness to engage on a per-word compensation structure at a rate of $0.0075 per so...

I have a database containing over 600 serial numbers. Email serial number has an associated email address. Instead of listing the same email address multiple times, I would like a script to place all serial numbers by one email address. This will enable me to email the customer once with ALL of their serial numbers in one email. Example: Hannah Walker appears in the database 5 times, the script should remove the four duplicates of Hannah Walker and put all 5 serial numbers by her name.

I am seeking the expertise of a professional engineer to create 2 sets of stamped engineering plans for a 7-10k elevator boat lift. The desgin should incorporate: - 20 degree angle lift secured to a seawall, indicating a balance of strength and flexibility. - Weight capacity between 5,000 - 10,000 lbs, to cater to a diverse range of boats. The ideal candidate should have: - Extensive experience in marine engineering - A proven track record with designing boat lifts - Familiarity with the local codes and regulations in Pasco County. For a smooth working relationship, the ability to respond promptly to queries and meet deadlines is crucial. Detailed and clear communication is also essential.

I am in need of a freelancer who can accurately convert my PDF files into Excel. The materials consist mainly of printed, electronically generated text. Given the nature of the work, the ideal candidate should: - Be proficient in both PDF and Excel formats - Have an eye for detail to ensure accuracy - Have experience dealing with extensive text documents - Possess strong typing and data entry skills Please bid if you fully understand the tasks and feel capable to deliver high-quality results. Your attention to detail and commitment to accurately completing tasks would make you an ideal candidate for this project.

I'm looking for a professional who can help me integrate my FreePBX system with an AI to automate and manage my call center. The ideal candidate should be able to: - Implement AI-driven call routing - Develop an AI voice bot - Configure ...FreePBX system with an AI to automate and manage my call center. The ideal candidate should be able to: - Implement AI-driven call routing - Develop an AI voice bot - Configure the AI voice bot to provide information, take orders and schedule appointments Key requirements: - Seamless integration between FreePBX and the AI system - Smooth call handling and routing - Accurate and relevant information delivery by the AI voice bot to the callers - AI system must be able to provide business hours, product descriptions and pricing infor...

I'm looking for Shopify store owners to install and test two Shopify apps. This project entails the following: - Installing and testing two Shopify apps. - Providing comprehensive feedback on the apps based on usability, performance, features, and overall experience. - The chosen apps should heavily emphasize social media promotion features. The ideal freelancer for this project should: - Have a good understanding of Shopify and its app ecosystem. - Be experienced in using and evaluating marketing apps. - Be able to provide detailed and constructive feedback. - Have a keen eye for user experience and app performance.

...The primary task is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks involving Excel report generation from SQL data - Excellent problem-solving skills and ...

...of short films that require advanced editing in Adobe Premiere Pro and After Effects. I'm looking for a talented freelancer who can take care of the following: - Advanced Editing: The films need to be edited in a sophisticated manner, with attention to detail and creativity. - Color Correction and Grading: I need both color correction and grading to be applied to the films. This includes ensuring the colors are consistent and enhancing the overall visual appeal. - Object Removal: There are certain objects and backgrounds in the films that need to be removed. This requires a high level of skill and precision. Ideal candidates for this job would have: - Proven experience in advanced editing in Adobe Premiere Pro and After Effects - Expertise in color correction and gr...

I'm looking for a skilled interior designer to bring my modern design concept to life through a high-quality rendering for linked bridge whose walls are approximately 400 meters long, approximately 8 meters wide and approximately 4 meters high. Its walls are glass and cladding, and it also has escalators. Key Requirements: - Visualize the Design: I need the freelancer to translate my design into a visually appealing and realistic 3D model. This will help me understand how the final space will look. - Client Presentation: The rendering should be of a quality that I can use it to present my design to clients. It should be professional, detailed, and showcase the key elements of the design concept. - Interior design rendering with pictures of the floors in the shape of a running trac...

...Preliminary and non-definitive mockups of the solution are provided in the appendix to illustrate the functional expectations. 2. Functional Scope The functional scope of the Mobile Money solution must cover at least: - Management of a virtual wallet account per user - Subscription/purchase of our mobile plans (Purchase of airtime/prepaid recharge...) - Person-to-person (P2P) money transfers between wallets - Cash withdrawal and recharge at our agencies or partner points of sale - Payment of bills to partner public service providers (water, electricity, cable TV, etc.) 3. Technical Components The overall architecture of the mobile money solution must include: - A secure central platform hosting all functionalities - A middleware layer for integration with external systems - A...

For my project, I'm looking for a highly detail-oriented professional with brilliant Excel skills. Key responsibilities include: - Managing and transferring both numerical and textual data in an Excel spreadsheet, ensuring the correct placement into columns marked by letters (A, B, C, etc). - You'll not be required to order the data in any specific way, just transfer into the appropriate columns. Skills & Experience: - Proven record in data entry tasks - Strong Excel skills - Ability to understand and interpret numerical and textual data Looking forward to your bids and kicking into this project soon!

I'm looking for a Figma expert to design the User Interface for my mobile app. The app is expected to have between 10-20 screens. Key Responsibilities: - Design the mobile app UI using Figma. - Design the UI in a way that is visually appealing and user-friendly. Ideal Skills and Experience: - Proficient in Figma and mobile UI design. - Strong understanding of user experience and user interface design. - Previous experience designing mobile apps with 10-20 screens. - Good at communication to understand the app's functionalities. If you are interested in this project, please share some of your previous work with me.

.../dev/video0. The stream is in Grayscale (RG12, 12bit) format and I need assistance in creating Python code to receive this stream and make it available in a CuPy array. The primary goal is to process this data in real-time for monitoring purposes. It is crucial that the data is not copied between CPU and GPU memory. Key Requirements: - Acquire data stream from /dev/video0 on Nvidia Jetson Orin and store as an array - Use Python 3.9+ for the codebase - Process the data array for real-time monitoring - Do not copy data between CPU and GPU memory, as one frame is 17MB in size Ideal freelancer for this project should have: - Extensive experience with Python, particularly in real-time data processing - Prior experience with Nvidia Jetson devices and GPU computing - Proficienc...

I'm in need of an engaging and interactive activity book to complement my upcoming children's book designed for children between the ages of 5 and 8. The activity book should contain 32-40 pages, combining a variety of activities to keep young minds entertained and stimulated. Key Requirements: - A blend of different activities: I'm looking for a mix of activities, particularly coloring pages, mazes, word scrambles, picture matching, and find objects in pictures. These activities should be both fun and educational, reinforcing the themes and characters of the book. - Specific Inclusions: The coloring pages should predominantly feature the main character of the book as well as key scenes. These illustrations should be vivid and appealing to children in the target ag...

We are seeking an experienced freelance develope...application for service providers. Responsibilities:Design and develop an intuitive user interface for three distinct profiles: clients (bailiffs), service providers (drivers, couriers, movers, locksmiths), and administrators. Integrate a real-time booking system with calendar and availability management. Implement secure payment systems and automatic notification features. Ensure compatibility between the web and mobile to best practices for security and data protection. Required Skills:Proven experience in web and mobile in front-end and back-end technologies (e.g., React, Node.js).Experience with SQL or NoSQL understanding of UX/UI design to meet deadlines.

I am seeking a skilled developer who can help me optimize my team's workflow and communication on Slack through the creation of automation bots. These bots should offer the following functionalities: - Message Scheduling: Automating message delivery at specific times. - File Sharing: Facilitating easy and organized file exchange between team members. - Task Assignment: Automating the delegation of tasks within the team. - Onboarding: Assisting with the onboarding process for new team members. I prefer the use of the Slack API to develop these bots. The ideal candidate should have a good understanding of this platform and be able to leverage its features effectively. User interaction with these bots should be seamless and intuitive. I envision the following methods: -...

Hello^^^^. I'm using Amazon AWS and would like to request server maintenance. First of all, I would like to ask you to do as much as possible for server security and privacy, such as SSL installation, automatic backup once a day, DDOS attack prevention, system performance optimization, hacking prevention, encryption between data transmissions, real-time monitoring, data recovery, backdoor checking, backdoor checking and deletion of compromised files, attack root identification and blocking, suspicious process occupation identification and recovery, server hacking analysis, server access history tracking, password recovery and complexity setting, virus and malicious software checking,,data leakage prevention.....etc My current monthly budget is about $50, Please send me a prop...

I'm in need of an experienced data entry specialist who can assist in uploading 850 products onto my online store. You will be provided with the necessary product information (description, price, specifications) in the format of Excel/CSV files. Your tasks will include: - Accurate data input of all relevant product details - Verification and correction of any existing data entries - Ensuring all listings are in sync with their corresponding inventory Ideal Skills: - Experience in data entry, particularly e-commerce product listing is preferred - Proficiency in Excel - Attention to detail and accuracy are extremely essential - Fast typing speed with a keen eye for details. Please only bid if you have relevant experience, and can start work promptly.

I need a freelancer to design and administer a survey aimed at collecting statistical data from university students. The main focus of this study will be establishing the relationship between technology integration and student engagement. Your responsibilities: - Design a survey that comprehensively captures information about students level of engagement when technology used during their academic activities. - Implement this survey and ensure a high response rate from the students. Ideal skills: - Previous experience in research design specifically targeting student demographics - Proficiency in data collection, interpretation and representation. - Familiarity with advanced technology trends in an academic setting. With the results, we can leverage technology more effectively ...

I'm looking for a Filipina social media expert to create engaging and inspiring content for women aged 40 and over. Your main tasks will be to create 2 different posts every Monday, Wednesday, and Friday, and post them 3 times per week across Facebook, Instagram, Twitter, and LinkedIn. In addition to this, you will also need to actively engage with our audience, liking, commenting, and responding. Key Requirements: - Social Media Savvy: Proficient in using Facebook, Instagram, Twitter and LinkedIn, with a good understanding of what makes content engaging on each platform. - Content Creation: Ability to create original, inspirational quotes, educational tips, success stories, and motivational posts. - Design Skills: Familiarity with tools like Canva or similar apps to create vi...

I'm looking for a professional who can assist me with the typing of my novel manuscript. Your responsibilities will include: - Accurately typing out my novel - Formatting the typed content into an e-book format The ideal freelancer for this job would be experienced in: - Typing - MS Word - Excel calculations - E-book formatting Having an RS-CIT certificate would be a major plus. The ability to pay close attention to detail and produce error-free work is paramount. Experience in typing and formatting novel manuscripts is highly preferred. Finally, quick turnaround time is necessary for the successful completion of this project.

I'm in need of a competent WordPress developer to assist me in make the site is in to two language English and Thai. You need to create multi language button. Customer able to switch back and forth between two language. I also need developer to update all new current plugin and make the site load faster. Need SEO plugin install and social networking login.

I'm in need of a personal website that is both aesthetically pleasing and functional. I'm looking for a classic and traditional visual style that will be appealing to visitors. The main feature of the site will be a live tracking page that provides real-time updates. This tracking page will need to be updated manually at times and also have the ability to automatically update information. Key Requirements: - 6-page personal website - Classic and traditional visual style - Functional, user-friendly layout - Live tracking page with both manual and automatic updating capabilities - Automated email alerts sent at specific intervals - The tracking page should include live updates Ideal Skills: - Proficiency in front-end and back-end web development - Experience in building pe...

I run a website development agency and I require a skilled communicator, ideally with conversational English skills, to get in touch with my clients. This person will be responsible for client onboarding and consultation. Key Responsibilities: - Engage in client onboarding. - Conduct consultations with clients to gather their project requirements. - Ensure smooth communication between clients and my development team. Ideal Candidate: - Should be a native or fluent English speaker. - Have a background in client management or customer service. - Be proficient in understanding and communicating technical requirements from clients. - Able to manage multiple clients at once (1-5 clients at a time). This role is crucial in ensuring that each project is initiated correctly, with all cl...

I'm looking for an animator who can help me create a 1-minute animation. I'm open to a realistic or simplified style, or anything in between. The animation will be focused on demonstrating construction techniques for renewable energy sources. Key Points: - Duration: 1 Minute - Style: Realistic or simplified - Audience: General public - Focus: Highlighting construction techniques for renewable energy sources Ideal Skills & Experience: - Proven experience with animations - Ability to create engaging content for the general public - Knowledge of renewable energy sources could be a plus, but not mandatory

I'm looking for an experienced freelancer who can create an Excel calculator for historical cryptocurrency prices from Binance and Luno. The calculator should also include fiat exchange rates for major currencies such as ZAR/USD bank sell rates Key Requirements: - Retrieve historical price data from Binance and Luno - Incorporate USD, and ZAR exchange rates - Organize the data and create user-friendly interface - Ensure accuracy and reliability of the calculator - Prioritizing the preservation of data privacy Ideal Skills: - Proficiency in Excel and data manipulation - Familiarity with cryptocurrency exchange APIs - Knowledge of major fiat currency exchange rates - Strong analytical and problem-solving abilities Please include your relevant experience in your applicat...

I’m looking for an experienced and skilled architect specializing in prefab design to create a residential dwelling that is between 1,000 and 5,000 sq ft. The property I'm envisioning is one that leverages modern and minimalist design principles. Specifics for this project: - Expert in modern and minimalist architectural design - Experience in designing prefabricated structures of similar size - Knowledge of space utilization to yield an open, spacious yet intimate dwelling The ideal candidate will be able to creatively interpret these requirements and devise a structure that is both aesthetically pleasing and practical for a residential setting. A strong portfolio of previous prefabricated home projects would be beneficial.

...encompassing both the beauty and the hardships that we face throughout our lives. Key Points: - Purpose: The primary aim of this memoir is personal storytelling. It's not just about me, but about the broader human experience as well. - Tone: I'm looking for a writer who can balance a mix of serious and humorous elements. This memoir should be insightful and introspective, yet also light-hearted at times. - Theme: The central theme of the memoir revolves around the dualities of life - the moments of beauty and the challenges that we encounter. Ideal Candidate: - Proven experience in writing memoirs or personal storytelling pieces. - Understanding of the American culture and investment industry. - Ability to seamlessly blend serious and light-hearted tones. - Understand...

I'm looking for a proficient social media specialist to manage accounts on Facebook, Instagram, and Twitter. The primary objective is to generate leads targeted to young adults between 18 - 24 years. Key Responsibilities: - Strategise and execute campaigns to engage and attract young adults - Measure and analyze the effectiveness of these strategies in lead generation - Maximizing online presence and audience engagement Skills and Experience: - Proven track record in lead generation via social media - Deep understanding of youth trends and interests - Expertise in Facebook, Instagram, and Twitter algorithms - Able to design captivating content that resonates with the young adult demographic - Strong analytical skills to assess campaign efficiency.

...will be shared across social media. The aim of this video is to increase enrollment and, while doing so, provide some information on the specific attributes of each of our five branches. The successful freelancer should ideally have: - Proven expertise in creating compelling live-action video content suitable for social media - Excellent storytelling skills and the ability to differentiate between the general and specific content provided for each branch - A high degree of adaptability to utilize the provided assets and similar video samples The video should be approximately 8 to 9 frames long; assets, including sample videos, will be provided to aid your creativity. Please note the goal is not to simply recreate the sample videos. You will need to flex your creative muscles ...

I would like to see the result statistic in %. Important, when i refresh the excel i always want to see the last 5, last 10 and last 15 results.

I have an excel file, need add product categorie on a column - budget 100€

For this delicate assignment, I'm searching for a skilled professional who can create a tasteful and elegant slideshow using personal photos. Specific requirements include: - Only photos will be used, no videos. - No requirement for music implementation. - Apply simple fade transitions between photos for consistency and smooth flow. The ideal candidate for this project will have experience in creating sentimental photo presentations, with excellent visual aesthetics understanding. A portfolio of previous similar work is highly desirable. Your reliability, understanding, and respect for the sensitiveness of this type of work are crucial.

...2D plan for a 250 sqm basement in a residential property. This plan should include the following: - Walls and partitions: The layout should define and differentiate the spaces in the house, ensuring a clear and practical flow. - Furniture layout: An optimal furniture layout for a property with more than 4 bedrooms. This should consider the size and placement of each room, ensuring a balance between functionality and aesthetic appeal. the plan to include the following 1- living (15 person)+ dining area (10 chairs) 2- office room 3- meditation room (330x250cm) 4- Guest room 5- small gym (could be integrated with office) 6- Game Room 7- Theater/cinema room 8- Storage Ideal candidates should have: - Proven experience in creating detailed 2D plans for residential propertie...

I'm in need of a professional to assist me with migrating customer data from the Trax system to AMOS, and upgrading an old version of AMOS to a newer version. Key Requirements: - Experience in data science and data migration is a must. - You should be capable...assist me with migrating customer data from the Trax system to AMOS, and upgrading an old version of AMOS to a newer version. Key Requirements: - Experience in data science and data migration is a must. - You should be capable of cleaning the data before the migration process. - Experience with Python is a bonus, as it may be beneficial for data cleaning and transformation. The volume of data is between 1GB and 10GB. The ideal candidate should be proficient in handling such sizes to ensure a smooth and efficient mig...

Hello, Looking for someone to create video ads from a mobile game, you will need to play the game, get footage from and then give me 5 horizontal video and 5 vertical ads each video needs to be between 15-30 seconds long If you understand that you need to create everything from scratch and can do it in a short time frame please type GREEN at the beginning of your proposal. Proposals without it will be ignored.