Convert Total Minutes to Years, Months, Weeks, and Days in Excel
Question details
Convert an elapsed number of minutes into years, months, weeks, days, hours, and minutes without using start or end dates.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- An elapsed duration needs to be broken into units using a generic month length.
- Observed behavior
- The desired result is a breakdown of the total minutes using fixed assumptions for years and months, rather than calendar dates.
Enter a nonnegative whole number of minutes in cell A2. The formulas below assume 365 days per year and 365/12 days per month, or 43,800 minutes per month.
Break down elapsed minutes with Excel helper columns
Use these formulas to calculate each unit from largest to smallest without relying on calendar dates.
Each formula subtracts the larger units already calculated. The resulting months are fixed at approximately 30.4167 days, so they do not represent calendar months.
In Excel, enter the total elapsed minutes in cell A2.
In B2, enter =INT(A2/525600).
In C2, enter =INT((A2-B2*525600)/43800).
In D2, enter =INT((A2-B2*525600-C2*43800)/10080).
In E2, enter =INT((A2-B2*525600-C2*43800-D2*10080)/1440).
In F2, enter =INT((A2-B2*525600-C2*43800-D2*10080-E2*1440)/60). In G2, enter =MOD(A2,60).
Label columns B through G Years, Months, Weeks, Days, Hours, and Minutes. Select B2:G2 and drag the fill handle down to calculate additional rows.

Break down total minutes with WPS Spreadsheets
Use helper columns and formulas in WPS Spreadsheets to convert elapsed minutes into fixed years, months, weeks, days, hours, and minutes.
- 1. Open a spreadsheet: Open WPS Spreadsheets, create or open a workbook, and enter a nonnegative whole number of minutes in A2.
- 2. Calculate years and months: Enter =INT(A2/525600) in B2 and =INT((A2-B2*525600)/43800) in C2.
- 3. Calculate weeks and days: Enter =INT((A2-B2*525600-C2*43800)/10080) in D2 and =INT((A2-B2*525600-C2*43800-D2*10080)/1440) in E2.
- 4. Calculate hours and minutes: Enter =INT((A2-B2*525600-C2*43800-D2*10080-E2*1440)/60) in F2 and =MOD(A2,60) in G2. Label the columns and drag the fill handle down for more rows.

Frequently Asked Questions
Why can't I use a date format to get elapsed years and months?
Calendar months and years vary in length, so an elapsed minute count alone cannot identify their actual lengths. Use fixed conversion assumptions or provide start and end dates.
How many minutes are in the generic month used here?
The formulas use 43,800 minutes per month: 365 days divided by 12, multiplied by 1,440 minutes per day. This is approximately 30.4167 days.
Can I apply the formulas to more than one duration?
Enter each total in column A, then select B2:G2 and drag the fill handle down to calculate the remaining rows.
Do these formulas account for leap years?
No. They treat every year as exactly 365 days. Calculating actual elapsed calendar years and months requires start and end dates.




