# Change HH:MM into seconds

**URL:** <https://discourse.nodered.org/t/change-hh-mm-into-seconds/39521>\
**Category:** General\
**Created:** [22 January 2021 01:24 UTC](https://discourse.nodered.org/t/change-hh-mm-into-seconds/39521 "2021-01-22T01:24:46Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mobile\_NR\_Env](https://avatars.discourse-cdn.com/v4/letter/m/8dc957/32.png) [@Mobile\_NR\_Env](https://discourse.nodered.org/u/Mobile_NR_Env)\
**Post date:** [22 January 2021 01:24 UTC](https://discourse.nodered.org/t/change-hh-mm-into-seconds/39521/1 "2021-01-22T01:24:46Z")

</div>

Hello.  
Anyone help?

How can I convert a time input of HH:MM (ie:07:30) into seconds (since midnight)?

Cheers!

---

<div class="post-metadata">

**Author:** ![JayDickson](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/jaydickson/32/90592_2.png) [@JayDickson](https://discourse.nodered.org/u/JayDickson)\
**Post date:** [22 January 2021 02:55 UTC](https://discourse.nodered.org/t/change-hh-mm-into-seconds/39521/2 "2021-01-22T02:55:09Z")

</div>

I'd recommend looking into [node-red-contrib-moment (node) - Node-RED](https://flows.nodered.org/node/node-red-contrib-moment)

---

<div class="post-metadata">

**Author:** ![bakman2](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bakman2/32/6207_2.png) [@bakman2](https://discourse.nodered.org/u/bakman2)\
**Post date:** [22 January 2021 05:41 UTC](https://discourse.nodered.org/t/change-hh-mm-into-seconds/39521/3 "2021-01-22T05:41:28Z")

</div>

You could use a function node:

```auto
p = msg.payload.split(":")
seconds = (p[0]*60)*60 + (p[1]*60)
return {payload:{input:msg.payload,seconds:seconds}}

```

Or a change node with a jsonata expression

```auto
$number($split(payload,":")[0])*60*60+$number($split(payload,":")[1])*60

```

 ![Screenshot 2021-01-22 at 06.41.00](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/e/f/effa996f6e9de7b914dd5e44cba2c6943949ff26.jpeg)

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [22 January 2021 07:20 UTC](https://discourse.nodered.org/t/change-hh-mm-into-seconds/39521/4 "2021-01-22T07:20:04Z")

</div>

Is that a string or what? If you don't know then feed it into a debug node and show us.

---

<div class="post-metadata">

**Author:** ![E1cid](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/e1cid/32/77971_2.png) [@E1cid](https://discourse.nodered.org/u/E1cid)\
**Post date:** [22 January 2021 08:30 UTC](https://discourse.nodered.org/t/change-hh-mm-into-seconds/39521/5 "2021-01-22T08:30:04Z")

</div>

with change node and JSONata

```auto
$toMillis("1970-01-01T"&payload&":00.000")/1000

```

with function node

```auto
msg.payload = new Date("1970-01-01T"+msg.payload+":00.000").valueOf()/1000;
return msg;

```

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [23 March 2021 08:30 UTC](https://discourse.nodered.org/t/change-hh-mm-into-seconds/39521/6 "2021-03-23T08:30:44Z")

</div>

Closed on 23 March 2021 08:30 UTC

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