How to Convert Project Lag from Minutes to Days in Microsoft Project
Question details
The user needs to convert task predecessor or successor lag times that are currently displayed in minutes back into days.

- Product
- Microsoft Project
- Device & OS
- not provided
- Scenario
- Fixing scheduling display issues where negative lag or specific scheduling settings caused task lag to be stored and displayed in minutes instead of days.
- Observed behavior
- Predecessor or successor lag is displayed in minute values (e.g., -480m), making it difficult to read and manage task relationships in the standard daily format.
Check your project's default working hours per day in the schedule options, as this value dictates the exact formula used to convert minutes back into working days.
Calculate and Update Lag Values Using Schedule Options
Find your daily working hours to calculate the conversion factor, then use the Find and Replace tool to update minute-based lags in bulk.
Because Microsoft Project calculates task durations based on your specific calendar, a single workday could be 8 hours, 10 hours, or another value. You must determine this baseline before converting minute values.
Navigate to 'File' > 'Options' > 'Schedule'. Look for the 'Hours per day' setting (for example, 8.00).
Multiply your daily working hours by 60. For an 8-hour workday, the factor is 480 minutes (8 x 60).
Divide your displayed minute lag by your conversion factor. For instance, if your lag is -960 minutes, divide it by 480 to get -2 days.
Press 'Ctrl + H' to open the Find and Replace dialog. Enter the specific minute value (e.g., '-480m') in the 'Find what' field, and enter the converted day value (e.g., '-1d') in the 'Replace with' field, then click 'Replace All'.

Isolate Minute Lags Using a Custom Filter
Create a custom filter to easily spot all tasks that have minute-based or negative lags so you can adjust them manually.
Looking for a Better Way to Manage Your Daily Office Work?
While Microsoft Project handles highly complex scheduling, WPS Office provides a free, lightweight, and highly compatible alternative for all your standard document, spreadsheet, and presentation needs. You can easily manage project timelines, budgets, and trackers using WPS Spreadsheet without wrestling with complicated lag settings.
- 1. Download WPS Office: Visit the official WPS website and download the free office suite for your operating system.
- 2. Explore Project Templates: Open WPS Spreadsheet, click on 'New', and browse the template library for easy-to-use project trackers and Gantt charts.
- 3. Manage projects easily: Input your tasks and durations directly into the spreadsheet templates without worrying about complex negative lag conversions.

Frequently Asked Questions
Why does Microsoft Project change my lag from days to minutes?
This usually occurs when you enter negative lag (also known as lead time) or when specific background scheduling settings force the software to calculate durations at a more granular, minute-based level.
Can I change the default duration unit in Microsoft Project?
Yes. You can adjust this by navigating to File > Options > Schedule, and selecting 'Days' from the 'Duration is entered in' dropdown menu.
What is a better alternative to using negative lag?
Instead of using negative lag, project management best practices suggest breaking larger tasks down into shorter, more manageable components and linking them with standard Finish-to-Start (FS) relationships with zero lag.




