1st the data date should be 8:00 am or the earliest times of any of your calendars.
2nd you can do a simple find and replace in excel find 12:00:00 AM and replace with 5:00:00 PM
the option is use the concatintion in excel lets say the cell in excel you need to change is cell F2 and lets say that cell H2 had the date ONLY now in cell I2 time in ' 5:00:00 PM now in cell J2 put in H2&I2
now copy this formula downs and then copy column J and pastes special VALUES for column J
3rd if you are trying to CHANGE TIMES when importing then for completed activities ONLY import the finish date and time first because if you have a 1 day activity and the start and finish dates are the same you can NOT make the start date TIME later than the finish date TIME so you have to change the finish date TIME FIRST then change the start date TIME.
Member for
16 years 3 monthsglad I could help
glad I could help
Member for
16 years 3 monthsglad I could help
glad I could help
Member for
12 years 5 monthsThanks! that was extremely
Thanks! that was extremely helpful, you are great.
Member for
16 years 3 monthscouple of things1st the data
couple of things
1st the data date should be 8:00 am or the earliest times of any of your calendars.
2nd you can do a simple find and replace in excel find 12:00:00 AM and replace with 5:00:00 PM
the option is use the concatintion in excel lets say the cell in excel you need to change is cell F2 and lets say that cell H2 had the date ONLY now in cell I2 time in ' 5:00:00 PM now in cell J2 put in H2&I2
now copy this formula downs and then copy column J and pastes special VALUES for column J
3rd if you are trying to CHANGE TIMES when importing then for completed activities ONLY import the finish date and time first because if you have a 1 day activity and the start and finish dates are the same you can NOT make the start date TIME later than the finish date TIME so you have to change the finish date TIME FIRST then change the start date TIME.
this will be a 2 step process.