We counted 24, didn't we? There are 12 hours in the morning from midnight to midday, and there are 12 hours in the afternoon in the night from midday through to midnight. And so, we can say that every day is 24 hours long.
Let's say another employee worked 7 hours and 45 minutes. To convert this to decimal form, you would divide the minutes worked by 60, which gives you 0.75. Then, you would add that decimal to the total number of hours worked, which gives you 7.75 hours.
There are 6 hours in 360 minutes. To calculate this answer, you would divide the total number of minutes (360) by the number of minutes in an hour (60) to get an answer of 6 hours.
The key is to understand that time in Excel is just a number. 1 day = 24 hours, and 1 hour = 0.0412 (1/24). That means 12 hours = 0.5, 6 hours = 0.25, and so on. Because time is just a number, you can add time to days and display the result using a custom number format, or with your own formula, as explained below.
Introduction: My name is Carlyn Walter, I am a lively, glamorous, healthy, clean, powerful, calm, combative person who loves writing and wants to share my knowledge and understanding with you.
We notice you're using an ad blocker
Without advertising income, we can't keep making this site awesome for you.