PRIMAVERA P6 Date Formats In Excel– Quick Data Hack || Primavera Tricks || dptutorials

In this tutorial, let us learn about a small data hack in Primavera P6.

While dealing with Primavera P6, you will likely copy-paste schedule directly from P6 into Excel for further analyzing.

we have to deal with few complications while doing this. like

when you copy this schedule into excel, some of the cells will be filled with non-date format.

This is caused by the suffix "A” for activities that have an actual date, and an “*” for activities that have some sort of constraint applied

So when you want to compare with the last updated schedule to find the variances in excel, you would be subtracting the current dates from previous dates.

you would need to replace the letter A with blank, like this to convert it to date format.

But, you might be facing problem to strip the “*” off.

press Ctrl+H, In the find/replace statement, use the string as ~*~ to find, because if we use only *, it will replace the entire string.

So in this way you can convert your fields into date formats for better analysis.

If you have enjoyed this tutorial, please give me a like, share and comment.

For further more interesting videos, please do subscribe dptutorials

For Personalized detail learning, write to [email protected]

If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later.

***********************************************
★ My Online Tutorials ► https://www.dptutorials.com

LEARNING RESOURCES I Recommend: https://www.dptutorials.com/resources

Subscribe for more Awesome Tutorials: http://goo.gl/NyAtg2

Support the Channel via shopping: http://ift.tt/2jH38PR

Tools that I use for Vlogging:
• Laptop: https://amzn.to/2E5U3MO
• Canon 200D Camera: https://amzn.to/2HglDYA
• Benro Tripod: https://amzn.to/2ExRvYj
• Blue yeti microphone: https://amzn.to/2VwZyPn
• Collar Microphone: https://amzn.to/2VyOdcM
• Bluedio Headset: https://amzn.to/2W3xUZX
• Screen recorder: https://techsmith.pxf.io/2BMjA
• Boom Arm Stand: https://amzn.to/2VCQNi7
• Zoom H1 Audio Recorder: https://amzn.to/2VDumsT
• Harison Softbox Studio Lights: https://amzn.to/2LY7x3u
• Chroma Key Green Screen: https://amzn.to/2ExTr31
• Background Support Stand: https://amzn.to/2McqnEv
• Acoustic Foam Background: https://amzn.to/2EoQ1zj
• USB RGB LED Strip: https://amzn.to/2VItKm4
• Wireless Mouse: https://amzn.to/2E23cpN


Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

***********************************************

You Can Connect with Me at:
YouTube: www.youtube.com/c/dptutorials
G+: http://ift.tt/2kAOpa6
Twitter: https://twitter.com/dptutorials15
Facebook: http://ift.tt/2kfRnDi
BlogSpot: http://ift.tt/2kB14dh

Follow:
www.dptutorials.com
www.askplanner.blogspot.com

Tags: -

P6:
primavera p6 training online, primavera p6, primavera p6 training, primavera p6 tutorial, oracle primavera, primavera p6 download, primavera 6, oracle primavera p6, primavera p6 free download, primavera project management, primavera project planner, primavera download, primavera online, primavera training, primavera software free download, youtube primavera, primavera tutorial, is primavera online easy, p6 online, primavera p6 complete video tutorial free download, critical path, oracle primavera, primavera p6, primavera, primavera software, construction project management software, project management software, project management books, microsoft project, project management courses, project management certification, online project management, project management tools, free project management software, project management training, best project management software, pmp certification, free project management tools, project management apps, microsoft project management, project management professional certification, google project management, ms project, agile project management, basecamp project management, project portfolio management, project management, project management system, scrum project management, open source project management, project management template, construction project management, project plan, project management professional, free project management, it project manager, project manager jobs