# Calculating total edit time

**URL:** <https://forum.getodk.org/t/calculating-total-edit-time/31469>\
**Category:** Support\
**Tags:** odk-xlsform\
**Created:** [December 1, 2020, 4:18pm UTC](https://forum.getodk.org/t/calculating-total-edit-time/31469 "2020-12-01T16:18:57Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![fmv](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/f/9dc877/32.png) [@fmv](https://forum.getodk.org/u/fmv)\
**Post date:** [December 1, 2020, 4:18pm UTC](https://forum.getodk.org/t/calculating-total-edit-time/31469/1 "2020-12-01T16:18:57Z")

</div>

Hi,  
I want to calculate the total editing time of a form, from start to end, if the enumerator saves it midway and then start editing later again I want that time too to be included but excluding the time form was not opened. what would be the calculation for this?

---

<div class="post-metadata">

**Author:** ![Grzesiek2010](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/grzesiek2010/32/2881_2.png) [@Grzesiek2010](https://forum.getodk.org/u/Grzesiek2010)\
**Post date:** [December 1, 2020, 4:30pm UTC](https://forum.getodk.org/t/calculating-total-edit-time/31469/2 "2020-12-01T16:30:21Z")

</div>

Hi @fmv  
welcome to the forum! Please [introduce yourself here!](https://forum.getodk.org/t/introduce-yourself-here/6671)

you can use [Logging enumerator behavior](https://docs.getodk.org/form-audit-log/) it won't give you one value which would be the total time but you will be able to calculate it in excel for example.