- Thank you received: 749
Time calculations
8 years 7 months ago - 8 years 7 months ago #6251
by bert
Time calculations was created by bert
Time calculations are not fully supported in iDoceo 4 but if you necessarily have to add minutes and seconds here is a template that shows how.
In our example, we have two time based columns (MM.SS) and we add them both in one final calculation Time1 + Time 2
We create two additional columns Time1 and Time2 which show MM.SS as total seconds (i.e. 3.00 minutes equals 180)
We'll keep working on our calculations to offer a more elegant alternative to this.
Please do not forget to add a nice review to iDoceo 4.2!
In our example, we have two time based columns (MM.SS) and we add them both in one final calculation Time1 + Time 2
We create two additional columns Time1 and Time2 which show MM.SS as total seconds (i.e. 3.00 minutes equals 180)
We'll keep working on our calculations to offer a more elegant alternative to this.
Please do not forget to add a nice review to iDoceo 4.2!
8 years 7 months ago - 8 years 7 months ago #6268
by bert
Replied by bert on topic Time calculations
In iDoceo 4.2.1 we've added the MODULO function which makes the previous configuration easier to read and manipulate.
This is the updated template, password 1234
For those not familiar with MODULO, it returns the remainder after a division of one number by another.
For instance, if we had 3.59 in a cell (3 minutes 59 seconds) the following formula MOD( 3.59, 1) would yield 0.59 (the remainder of 3.59 divided by 1)
The conversion of MM.SS into total seconds would look like this image below. The first part obtains full minutes and converts it to seconds (x60) and the second part adds the remaining seconds.
This is the updated template, password 1234
For those not familiar with MODULO, it returns the remainder after a division of one number by another.
For instance, if we had 3.59 in a cell (3 minutes 59 seconds) the following formula MOD( 3.59, 1) would yield 0.59 (the remainder of 3.59 divided by 1)
The conversion of MM.SS into total seconds would look like this image below. The first part obtains full minutes and converts it to seconds (x60) and the second part adds the remaining seconds.