Convert total hours into standard 24-hour calendar days or custom business workdays (8-hour day) instantly — free, accurate, no signup required.
Converting total hours into days depends on your context. If you are calculating elapsed chronological time, you divide by 24 (the standard calendar day). However, if you are calculating business schedules or project timelines, you divide by your standard workday length (usually 8 hours).
To convert a total hours value (e.g. 120 hours in cell A1) to days in Microsoft Excel or Google Sheets, use the appropriate formula:
=A1/24 (For Calendar Days)
=A1/8 (For Standard 8-Hour Workdays)
Tip: Keep the destination cell formatted as General or Number with two decimal places to see exact fractional days (e.g. 1.67).
In project planning and resource scheduling, professionals often calculate efforts in "man-days" or "person-days." Under standard professional guidelines, a man-day represents exactly 8 hours of productive work. Estimating a software sprint or construction timeline in days means dividing the total projected hours by 8, not 24.
This table compares common hourly values converted into both standard calendar days (24h) and standard professional workdays (8h):
| Hours | Calendar Days (24h) | Business Workdays (8h) |
|---|---|---|
| 8 hours | 0.33 days | 1.00 workday |
| 24 hours | 1.00 day | 3.00 workdays |
| 40 hours | 1.67 days | 5.00 workdays |
| 80 hours | 3.33 days | 10.00 workdays |
| 120 hours | 5.00 days | 15.00 workdays |
| 160 hours | 6.67 days | 20.00 workdays |
Quick answers to common questions about converting hours to days.
To convert hours to standard calendar days, divide the total hours by 24 (the number of hours in a single day). For example, 48 hours divided by 24 equals 2 calendar days. To convert hours to standard workdays, divide the hours by your workday length (usually 8 hours). For example, 40 hours divided by 8 equals 5 workdays.
40 hours represents exactly 5 standard 8-hour workdays. This calculation is: 40 ÷ 8 = 5, which represents a standard full-time workweek.
120 hours is exactly 5 calendar days (120 ÷ 24 = 5). However, if you are planning resources or project estimates in a business environment with standard 8-hour shifts, 120 hours represents exactly 15 business workdays (120 ÷ 8 = 15).
In Microsoft Excel or Google Sheets, if cell A1 contains your total hours: to find standard calendar days, enter =A1/24. To find standard 8-hour business workdays, enter =A1/8. Keep the cell destination formatted as a Number with decimal places to show exact fractional days.
All the time conversion tools you need, completely free.
Convert hours and minutes to decimal format for payroll and timesheets.
Convert decimal hours back to hours and minutes format (HH:MM).
Convert any decimal time like 7.75 back to hours and minutes instantly.
Add multiple time entries and get total decimal hours for the week.
Calculate gross pay by multiplying decimal hours by your hourly rate.
Full reference chart — every minute from 1 to 60 in decimal format.
Calculate total hours worked between start/end times with break deduction.
Multiply hours, minutes, and seconds by any multiplier factor instantly.