time addition

  • Resolved civilvicky

    (@civilvicky)


    3 years, 3 months ago

    Is it possible to add two time.

    Take input from users about the two times

    for example: time 1 + time 2 = result.

    the input should be in hours: minutes : seconds

Viewing 1 replies (of 1 total)
  • Plugin Author codepeople

    (@codepeople)

    3 years, 3 months ago

    Hello @civilvicky

    If you have the text line fields fieldname1 and fieldname2, you can implement the equation as follows:

    DECIMALTOTIME(SUM(TIMETODECIMAL(fieldname1, 'h:i:s', 's'), TIMETODECIMAL(fieldname2, 'h:i:s', 's')), 's', 'h:i:s')

    The equation uses the TIMETODECIMAL operation to transform values in time format to decimal in seconds, sum them and then uses the DECIMALTOTIME to transform the result from seconds to time format again.

    Best regards.

Viewing 1 replies (of 1 total)

The topic ‘time addition’ is closed to new replies.