General

Re: How to convert time into seconds

donstephen — Mon, 01 Dec 2014 08:51:00 GMT

Or better yet, use this formula instead:

substring(TimeField, 1, 2) * 3600 + substring(TimeField, 4, 2) * 60 + substring(TimeField, 7, 2)

Re: How to convert time into seconds

donstephen — Mon, 01 Dec 2014 08:46:22 GMT

Hi Upender,

The formula below extracts the minutes section from the TimeField and then multiplies it to 60. After the minutes portion of the TimeField has been converted to seconds, I then extracted the seconds portion and simply added it to the previous data.

(substring-before(substring-after(TimeField, ":"), ":") * 60) + (substring-before(substring-after(substring-after(TimeField, ":"), ":"), "+"))

where TimeField is the field which holds the time.

You can also perform this approach to the hours portion - extract the hours and then multiply it to 3600, then add this value to the other values (formula above).

I haven't encountered any way yet to disable the CTRL + Z function since this is a global command or a hot key of some sort.

Hope this helps.

How to convert time into seconds

Upender Singh — Tue, 04 Nov 2014 15:15:59 GMT

Hello,

I have two questions.

1 - I have created a form wherein the time is in format of 00:35:15 how can i convert it in seconds.

2 - Is there is any possiblity to disable the Ctrl+Z function to avoid data furging.

Thanks for your support.

regards,

Upender Singh