---
title: "Time format is not exported correctly"
url: "https://openforis.support/questions/3242/time-format-is-not-exported-correctly"
tags: ["collect"]
status: "answered"
score: 0
answer_count: 2
asked: "2021-09-21T12:04:23"
last_activity: "2021-09-21T13:10:59"
source: "Open Foris Support - Q&A Forum"
license: "Copyright Open Foris, 2026. Some rights reserved under creative commons license."
---

# Time format is not exported correctly

Asked by mizehnder on 2021-09-21

Hi guys,

I have encountered an issue with the **time format** when I export the data from openforis desktop to .csv or .xslx. Whenever the time recorded in openforis is e.g. **14:05** or **09:08**, it skipps the zeros and exports it as **14:5**, respectively **9:8** - which is something that **R** cannot deal with very well. for any times without zeros, this does not happen. The attribute format is set as "time" in the survey designer. Does anybody know how to avoid this issue?

version openforis desktop: 4.0.20

Cheers,
Michael


## Answer (score 1, by Stefano (OF) on 2021-09-21)

Link: https://openforis.support/questions/3242/time-format-is-not-exported-correctly/3244

Dear Michael,  
If you are talking about exporting the data with the option "Include composite attributes merged column" selected, we will fix this problem very soon with the next release of Collect.  
Many thanks,  
Open Foris Team


## Answer (score 1, by mizehnder on 2021-09-21)

Link: https://openforis.support/questions/3242/time-format-is-not-exported-correctly/3245

Hi!

This is indeed what I am talking about. Glad to hear that you are already working on it! 

cheers,
Michael