SUM TIME WITH NUMBERS

Hello @graicifyd

What represents the number field in the fieldname110, hours, minutes, seconds?

If this number field represents the value in hours, you can implement the equation as follows:

GETDATETIMESTRING(DATETIMESUM(fieldname109, 'hh:ii', fieldname110, 'h'), 'hh:ii a')

More information about the date/time operations module by visiting the following link to the plugin documentation:

https://cff.dwbooster.com/documentation#datetime-module

Best regards.

The number field represents minutes.

Thank you.

Hello @graicifyd

In this case, you should edit the equation as follows:

GETDATETIMESTRING(DATETIMESUM(fieldname109, 'hh:ii', fieldname110, 'i'), 'hh:ii a')

Best regards.

It is adding one hour extra.

Instead of 5:00 + 10 being 5:10, it gives 6:10.

Thank you so much for your help.

Hello @graicifyd

I guess you are not editing the equation as should. Please, watch the following video:

https://resources.developers4web.com/cff/tmp/2022/08/17/video-date-operation_o.mp4

Best regards.

You’re correct.

It’s working correctly now.

Thank you for your help.

Please can you help me with what the operation would be if I want to subtract instead of summing up?

Hello @graicifyd

Use a negative number:

GETDATETIMESTRING(DATETIMESUM(fieldname109, 'hh:ii', -1*fieldname110, 'i'), 'hh:ii a')

Best regards.

Thank you so much.

I am grateful.