This is so simple, I kick myself for not seeing it (duh). All I had to do was create two new UDFs - MINh and MAXh for my Minimum and Maximum ranges. Then run a global multiplying the existing MIN and MAX by either 8, 10, or 24 depending on which calendar was used by the activity. Finally, when importing into PRA I used hours instead of days and MINh and MAXh as the range parameters at import. Worked beautifully.
So pleased with myself that I may create a short video explaining the process. I expect a couple of "You didn't know that? It is so obvious."
This is the link to the video. If there are any problems with the methodology, let me know.
Member for
18 years 6 monthsAll;This is so simple, I kick
All;
This is so simple, I kick myself for not seeing it (duh). All I had to do was create two new UDFs - MINh and MAXh for my Minimum and Maximum ranges. Then run a global multiplying the existing MIN and MAX by either 8, 10, or 24 depending on which calendar was used by the activity. Finally, when importing into PRA I used hours instead of days and MINh and MAXh as the range parameters at import. Worked beautifully.
So pleased with myself that I may create a short video explaining the process. I expect a couple of "You didn't know that? It is so obvious."
This is the link to the video. If there are any problems with the methodology, let me know.
http://www.youtube.com/my_videos_edit?ns=1&video_id=T62aL-OuNDg