time addition | WordPress.org

[ad_1]

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.

 

This site will teach you how to build a WordPress website for beginners. We will cover everything from installing WordPress to adding pages, posts, and images to your site. You will learn how to customize your site with themes and plugins, as well as how to market your site online.

Buy WordPress Transfer