# Include seconds in timedelta format on export

**URL:** https://discuss.tryton.org/t/include-seconds-in-timedelta-format-on-export/3450
**Category:** Ideas
**Created:** [November 12, 2020, 2:37pm UTC](https://discuss.tryton.org/t/include-seconds-in-timedelta-format-on-export/3450 "2020-11-12T14:37:16Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![pokoli](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/pokoli/32/22_2.png) [@pokoli](https://discuss.tryton.org/u/pokoli)
#### Post date: [November 12, 2020, 2:37pm UTC](https://discuss.tryton.org/t/include-seconds-in-timedelta-format-on-export/3450/1 "2020-11-12T14:37:16Z")

</div>

Currently the timedelta fields are exported as HH:MM (seconds are included only when non empty) but this format is not managed by libreoffice to perform operations (i.e sum).

I think it will be good to export the format using the expected time format for the spreedsheet. Do you think this will be a good addition?

---

<div class="post-metadata">

### Author: ![ced](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/ced/32/1237_2.png) [@ced](https://discuss.tryton.org/u/ced)
#### Post date: [November 12, 2020, 5:05pm UTC](https://discuss.tryton.org/t/include-seconds-in-timedelta-format-on-export/3450/2 "2020-11-12T17:05:12Z")

</div>

> [@pokoli](#):
>
> this format is not managed by libreoffice to perform operations

On my LibreOffice (6.4.6.2), it is.

> [@pokoli](#):
>
> I think it will be good to export the format using the expected time format for the spreedsheet. Do you think this will be a good addition?

I think even if the spreadsheet program does not auto-detect it as time, you can apply manually a time format on the column.  
So for me we do not need to adapt as our format is quite standard.