I have an arrayformula column that subtracts datetimes resulting in a duration. I format that result using Elapsed time custom formatting in Sheets:
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.