http://office.microsoft.com/en-us/excel-help/dates-in-powerpivot-HA102836917.aspx
The "Truncate times if..." tip there helped me in analyzing the email log files I downloaded from SFDC. The timestamps came in this format "7/2/2013 6:41:40 PM", so a TRUNC([EmailDate], 0) gives me an easy way to group things right after importing the log into PowerPivot.
No comments:
Post a Comment