# Calcular tiempo

**URL:** <https://discourse.nodered.org/t/calcular-tiempo/41480>\
**Category:** General\
**Created:** [23 February 2021 12:29 UTC](https://discourse.nodered.org/t/calcular-tiempo/41480 "2021-02-23T12:29:56Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![novato1221](https://avatars.discourse-cdn.com/v4/letter/n/e19b73/32.png) [@novato1221](https://discourse.nodered.org/u/novato1221)\
**Post date:** [23 February 2021 12:29 UTC](https://discourse.nodered.org/t/calcular-tiempo/41480/1 "2021-02-23T12:29:56Z")

</div>

Hola a todos, estoy realizando un programa en el que introduzco la hora y estado de una máquina en una base de datos. El estado que se envía es 1 cuando funciona y 0 si se ha parado. Posteriormente realizo una consulta para obtener esos datos y calcular el tiempo que la máquina ha estado parada o funcionando. ¿Cómo puedo calcular estos tiempos?. Con un for recorro el array.  
Un saludo

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [23 February 2021 12:40 UTC](https://discourse.nodered.org/t/calcular-tiempo/41480/2 "2021-02-23T12:40:19Z")

</div>

If you are using a SQL database, you should be able to do the calculation in SQL. Using `GROUP BY`

---

<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:** [24 April 2021 12:40 UTC](https://discourse.nodered.org/t/calcular-tiempo/41480/3 "2021-04-24T12:40:21Z")

</div>

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