Comment calculer les heures de travail et supplémentaires sur Excel ? (Planning hebdomadaire)

🚨 Test your Excel skills (with answer key) and receive exclusive resources 🎯 ➜ https://www.morpheus-formation.fr/blo... 🎁 Follow our free Excel training → https://www.morpheus-formation.fr/for... 🏆 Excel training eligible for CPF funding – Up to 100% financeable, all levels, 100% personalized → https://www.morpheus-formation.fr/for... 💡 ABOUT THIS VIDEO The time format (hh:mm) is a unique format built into Excel. For example, when you enter "12:00", if you apply a number format to the cell, the result will be "0.5". This is because "12:00" represents half the day. In other words, the Time format is a number between 0 and 1 that represents the time of day. To go further and add up working hours beyond 24 hours, you absolutely must use the custom format "[h]:mm"! Otherwise, the calculation "24:00 + 12:00" will return "12:00", not "36:00". I'll also show you how to convert a time into a number in a calculation. Spoiler alert: you just multiply the time by 24... 🏢 WHO ARE WE? Morpheus Formation is an organization 100% specialized in Excel and its latest features. Has your company and your profession evolved over the last 15 years? Excel too! With a satisfaction rating of 9.8/10 in 2024, we have already supported over 500 learners and 50 companies, including Pernod Ricard, Cartier, and Orange. Our Excel training courses are suitable for both businesses and individuals, with personalized support using your own files. 🎓 OUR EXCEL TRAINING COURSES 1️⃣ Personalized training, delivered live by an expert instructor, tailored to your needs. 2️⃣ Exclusive exercise materials and the option to work on your files during the sessions. 3️⃣ Ultra-flexible scheduling (weekdays, holidays, weekends, etc.). 📌 Excel Training for All Levels → https://www.morpheus-formation.fr/for... 💡 CHAPTERS 00:00: Intro 00:44: Understanding the Time and [h]:mm format 02:21: Calculating Hours Worked per Day and per Week 03:08: Calculating Overtime 03:20: Converting an Hour to a Number in a Calculation 04:33: Going Further 04:57: Outro 🎁 OTHER FREE RESOURCES 📂 20 Excel Exercises to Progress Quickly → https://www.morpheus-formation.fr/blo... 📥 Free PDF: 25 Essential Excel Functions → https://www.morpheus-formation.fr/blo... ⌨️ 20 Excel keyboard shortcuts to remember → https://www.morpheus-formation.fr/blo... 📬 FOLLOW US 🌐 Official website → https://www.morpheus-formation.fr/ 💼 LinkedIn →   / morpheus-formation