iDoceo 7 for macOS and iPadOS now available!

You will find all the details explained here
Welcome, Guest
Username: Password: Remember me

TOPIC: Time calculations

Time calculations 4 years 6 months ago #6251

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 3261
  • Thank you received: 616
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!

IMG_0742.png
Please take a moment to add or update your rating for iDoceo 7 teacher gradebook so that we can continue working on it. Thanks!
Here is the link
apps.apple.com/app/apple-store/id4771209...&action=write-review
Last Edit: 4 years 6 months ago by bert. Reason: Removed template
The administrator has disabled public write access.
The following user(s) said Thank You: brettm

Time calculations 4 years 6 months ago #6268

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 3261
  • Thank you received: 616
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

File Attachment:

File Name: Time_calculations.idoceo
File Size: 2 KB



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.


IMG_0051.png
Please take a moment to add or update your rating for iDoceo 7 teacher gradebook so that we can continue working on it. Thanks!
Here is the link
apps.apple.com/app/apple-store/id4771209...&action=write-review
Last Edit: 4 years 6 months ago by bert.
The administrator has disabled public write access.
Time to create page: 0.106 seconds
21 AUG

iDoceo 7 for iPad and Mac now available!

A huge update with tons of new features and a new interface

Read more

6 JUN

Create Multiple-choice tests with iDoceo Connect!

In addition to self-evaluation rubrics, your students can now fill exams online. Supports text and images - in answers and questions - and can easily be imported from an XLS template

Read more

Cookies policy

This website uses cookies to make it easier for you to use the forum. We do not track you for any kind of advertising or statistics. Cookies are only used to keep you logged in the forum in case you would like to post and to keep your language selection in case you use the automatic translation offered by Google. If you continue to use our offer and have activated this technology in your browser, you consent to the use of cookies.