Excel Export Issues

Has anyone had the following issue? It i driving me crazy. 

When I export a project or a report, the Time (hh:mm) export as a date time entry. It shows in the field correctly but if you click on the cell in formula bar it is reading either M/D/YYYY (1/2/1900  8:00:00 AM) or time (8:00:00 AM). When I try to change the format to a number format, it converts to a value unrelated to the hours originally shown, for example, 56:00 converts to 2.33. I need to pull this information to do calculations for reporting. Are there any settings that I am unaware of that need to be changed in Wrike?

0
1 commentaire
Spot On Innovative Approach Stellar Advice
Avatar
Stephen

Hi Suzanne, I can see you've reached out to Support about this and they've requested a screenshot of what you're seeing.

From what I can see this is how Excel displays this type of captured data however if you follow up with Support's email with a screen capture of what's happening, they can review and suggest some workarounds 👍

0
Actions pour les commentaires Permalien

Folllowing List for Post: Excel Export Issues
[this list is visible for admins and agents only]

Haut de la page
Didn’t find what you were looking for? Write new post