# H:mm:ss - h:mm:ss = h:mm?

**URL:** <https://community.thunkable.com/t/hss-hss-h-mm/2973857>\
**Category:** Questions about Thunkable X\
**Created:** [April 28, 2024, 9:22pm UTC](https://community.thunkable.com/t/hss-hss-h-mm/2973857 "2024-04-28T21:22:46Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![nuuzonessqnzvv](https://avatars.discourse-cdn.com/v4/letter/n/bbce88/32.png) [@nuuzonessqnzvv](https://community.thunkable.com/u/nuuzonessqnzvv)\
**Post date:** [April 28, 2024, 9:22pm UTC](https://community.thunkable.com/t/hss-hss-h-mm/2973857/1 "2024-04-28T21:22:46Z")

</div>

Hi all,

I have determined the elapsed time between 2 timestamps in a local db, tag 1 & tag 2 (seen in pic below). This should equal 00.01.15

 ![20240428_205437000_iOS](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/d/ed370bb7ea35b9c6389401a68f87fd44d0b5e1ed.jpeg)

I used the blocks below and get an elapsed time of 00.01. This excludes the seconds and has formatted it in h:mm rather than h:mm:ss.  
How can i get it to include the seconds in the elapsed time??

 ![Screenshot 2024-04-28 215013](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/a/cafc14a386b6019d39409899f1b835e444b949cc.png)  
 ![20240428_205455000_iOS](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/b/9b7e13239b627ad00846140f0a780aaf75d7ade7.jpeg)

Thank you

---

<div class="post-metadata">

**Author:** ![steve\_synopsis](https://avatars.discourse-cdn.com/v4/letter/s/48db29/32.png) [@steve\_synopsis](https://community.thunkable.com/u/steve_synopsis)\
**Post date:** [April 28, 2024, 11:16pm UTC](https://community.thunkable.com/t/hss-hss-h-mm/2973857/2 "2024-04-28T23:16:43Z")

</div>

Hi,

A time of 21.52.22 is not valid, and as far as I know Thunkable does not store time as hh:mm:ss from a variable or a table.

I would suggest that you have to store your time in the database as seconds only. You can do the elapsed time duration and then convert it to hours, minutes and seconds.

---

<div class="post-metadata">

**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\
**Post date:** [April 29, 2024, 12:16am UTC](https://community.thunkable.com/t/hss-hss-h-mm/2973857/3 "2024-04-29T00:16:43Z")

</div>

You left out a key detail which is how you’re storing the timestamps. If you’re using the `seconds since 1970` block, then it will return a value in hundredths of a second such as 5.63 which is 5 seconds and 63/100 seconds.

If you subtract two such values, you should get a number with a hundredths value.

–––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––  
Need help on the forums? Make sure to read this: [How to ask Great Questions v2.0](https://community.thunkable.com/t/how-to-ask-great-questions-v2-0/2689983)

Want to hire a Certified Thunkable Expert? [Tatian G | Profile | Fiverr](https://www.fiverr.com/tatiang)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\
**Post date:** [July 28, 2024, 12:17am UTC](https://community.thunkable.com/t/hss-hss-h-mm/2973857/4 "2024-07-28T00:17:04Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.