Hi, I'm trying to write a function to give me the duration in minutes from two times in the same payload. For example 17:45 to 18:45 would give me a duration of 60min. Do you guys know how I can achieve that? Many thanks [image]

Here you go: [Capture] [{"id":"52c45c6e.1729a4","type":"function","z":"e39579ff.bf2ad","name":"","func":"var time1 = new Date(\"1970-01-01 \" + msg.payload.time1);\nvar time2 = new Date(\"1970-01-01 \" + msg.payload.time2);\nvar diff = time2-time1\n\nmsg.payload = (diff /1000)/60\n\nreturn msg;","…

Thanks for your suggestion @edje11 . I actually saw it earlier this morning and tried it but because mine isn't a timestamp and I have the HH:MM format I got stuck.

Node-RED

Node-RED Forum

Duration in MM between two times

General

edje11 16 September 2022 11:29 2

Have a look at this topic.

Topic		Replies	Views
Calculate time difference General	13	5041	31 May 2022
Calculate the seconds between two timestamps General function-node	2	2609	23 April 2022
How to calculate time difference between two timestamps? General	7	3308	10 September 2022
Calculating days and hours between two timestamps - Almost there.. Need a tweak on this! General	5	311	6 February 2023
How to calculate time difference? General	4	11716	12 February 2019

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Duration in MM between two times

Related topics