Project data and time imported into Excel - How to remove time portion

[Daryl]

Hi
I am exporting date fields from Microsoft Project into Excel, the problem I
am having is finding a way of getting rid of the time portion as it is
interferring with the calculation.

I understand that a date and time is stored as a double, the integer part is
the date and the decimal part is the time. I would like to easily remove
the decimal part of the imported part.

Any help would be good.

thanks
daryl

 

[Pete_UK]

You might want to split the time and date into two separate columns.
If your date/time is in A1, you can split them like this:

B1: =INT(A1)
C1: =MOD(A1,1)

Format the cells appropriately, then copy down the columns. You can
fix the values by highlighting them, then <copy>, then Edit | Paste
Special | Values (check) | OK then <Enter>, and then you can delete
the original column A.

Hope this helps.

Pete