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

How to create a pivot table in Excel? - Interactive exercise #tcd

#1 Créer un agenda sur GoogleSheets

Créer un tableau de Bord sur Excel interactif que vous pouvez actualiser pour le mettre à jour

Faire une feuille d'heure hebdomadaire sur Excel (+ heures sup)

Le calcul des heures supplémentaires

Excel : les Fonctions et Formules les plus UTILES !

Excel - Comment calculer des Heures supplementaires ?
![[1/4] Formation Power Query — les bases à savoir !](https://i.ytimg.com/vi/4rCgZX9jEnA/hqdefault.jpg?sqp=-oaymwEjCNACELwBSFryq4qpAxUIARUAAAAAGAElAADIQj0AgKJDeAE=&rs=AOn4CLC0qBdDfwAPGz73m3Fkcz3pumm1tw)
[1/4] Formation Power Query — les bases à savoir !

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

Heures Négatives Excel

Envoyer 1000 mails depuis Word et Excel : le publipostage

Pink Aura Screensaver Background – Soft Aesthetic Wall Art 4K

💼 Créer un tableau Excel pour calculer tes heures de travail et heures supplémentaires 🕒
![Art Wallpaper • Van Gogh • no sound • [4k]](https://i.ytimg.com/vi/GlkxpF6DkRE/hqdefault.jpg?sqp=-oaymwEjCNACELwBSFryq4qpAxUIARUAAAAAGAElAADIQj0AgKJDeAE=&rs=AOn4CLB3LiNfgLxULdjy0g3E3_mnqkf8Ag)
Art Wallpaper • Van Gogh • no sound • [4k]

Comment calculer ses heures de travail pour la semaine | Tutoriel Excel - DE RIEN

EXCEL pour COMPTABLE : La formation complète de A à Z

HD Flower TV Screensaver , Framed Art Painting, TV Art - Nas Gallery

Excel: Mastering Pivot Tables - COMPLETE GUIDE 2026

Astuce Excel pour maîtriser la soustraction des heures et faire le cumul des heures ! ⌚👍

