Tickets & Conversations

meoquytoc
Membre

Convert duration data type

Résolue

 

Hello everyone,

 

I tried to export the "Time to close" property which is the amount of time from the ticket create date to the ticket end date to the CSV file (picture one).

Picture 1Picture 1
Instead of getting the duration of time like the first picture, I got the date data type that starts from 1900 (picture 2)

Picture 2Picture 2
I wonder what is the keyword for the date data type that I got in the CSV file and what is the guideline to convert date data back to duration like in picture 1

0 Votes
1 Solution acceptée
karstenkoehler
Solution
Au panthéon de la communauté | Partenaire solutions
Au panthéon de la communauté | Partenaire solutions

Convert duration data type

Résolue

Hi @meoquytoc,

 

2/8/2019 is the date that Excel defaults to when it cannot recognize another date. When you type the '959:02:17' into a new cell in a new Excel document, this happens, too:

 

karstenkoehler_0-1669053522048.png

 

When you right click into the cell > Format Cells > Number, you will get a formatting like the HubSpot column:

 

karstenkoehler_1-1669053666886.png

 

Best regards!

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

Voir la solution dans l'envoi d'origine

1 Réponse
karstenkoehler
Solution
Au panthéon de la communauté | Partenaire solutions
Au panthéon de la communauté | Partenaire solutions

Convert duration data type

Résolue

Hi @meoquytoc,

 

2/8/2019 is the date that Excel defaults to when it cannot recognize another date. When you type the '959:02:17' into a new cell in a new Excel document, this happens, too:

 

karstenkoehler_0-1669053522048.png

 

When you right click into the cell > Format Cells > Number, you will get a formatting like the HubSpot column:

 

karstenkoehler_1-1669053666886.png

 

Best regards!

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.