# Sheets Elapsed Time formatting not preserved on new rows

**URL:** https://community.glideapps.com/t/sheets-elapsed-time-formatting-not-preserved-on-new-rows/14036
**Category:** Ask for Help
**Created:** [August 15, 2020, 5:45pm UTC](https://community.glideapps.com/t/sheets-elapsed-time-formatting-not-preserved-on-new-rows/14036 "2020-08-15T17:45:51Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![Adam\_Acosta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adam_acosta/32/73_2.png) [@Adam\_Acosta](https://community.glideapps.com/u/Adam_Acosta)
#### Post date: [August 15, 2020, 5:45pm UTC](https://community.glideapps.com/t/sheets-elapsed-time-formatting-not-preserved-on-new-rows/14036/1 "2020-08-15T17:45:52Z")

</div>

I have an arrayformula column that subtracts datetimes resulting in a duration. I format that result using Elapsed time custom formatting in Sheets:

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/1a7e0e3fdb56a97bad5a9c7ce5c5cc73ceaaf03c.png)

Problem is when new records are added, that nice formatting (h:mm) is not preserved. Resulting in decimal numbers like 0.377773. Not sure if this is a Glide or Sheets issue.

I know I can write a formula that’ll give me what I want but it would be quite messy compared to a simple [End Time - Start Time] formula.