Hi there,
I have a report from Salesforce which returns time to complete a task as say "5 days 18 hours 19 minutes" or "0 days 1 hours 23 minutes". Is there a way I can have this show in a way Excel can understand i.e. hh:mm or dd:hh:mm? I am using a pivot table to pull the data together so may need to reference the pivot table info to a new tab for the format to appear correctly.
Any help would be appreciated.
Thanks
Bookmarks