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

  • Thread starter Thread starter Daryl
  • Start date Start date
D

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
 
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
 
Back
Top