0

Sum of "Hours" up to "todays hours"

Hi,

I have a list of time records ordered by date, i.e.:

- 01-jan-2022, used time 01:30 Hours

- 02-jan-2022, used time 00:25 Hours

- 05-jan-2022, used time 02:35 Hours.

...

etc

I'd like to add to every register accumulated hours up to current date, i.e.:

- 01-jan-2022, used time 01:30 Hours, accumulated time 01:30 Hours

- 02-jan-2022, used time 00:25 Hours, accumulated time 01: 55Hours

- 05-jan-2022, used time 02:35 Hours, accumulated time 04:30 Hours

...

etc.

Could anyone help me?

Thanks.

9 replies

null
    • Fred
    • 2 yrs ago
    • Reported - view

    Please tell us the names and type of fields you are using.

      • raisla67
      • 2 yrs ago
      • Reported - view

      Fred 

      Sorry, data types are:

      Date for Date

      Time for Time of use

      Text for Registration

      Thanks

    • raisla67
    • 2 yrs ago
    • Reported - view

    Hi Fred,

    I forgot tell you that there are different options:

    Fields are:

    - Date

    - Registration (for instance for a car, airplane, etc)

    - Time of use (this day and this registration)

    So i.e.,

    Reg. AA1234DD,         Date 14-may-22,         Time of use: 1:00H,         Accumulated: 1:00H

    Reg. ZZ4567GG,         Date 20-june-22,         Time of use: 0:30H,         Accumulated: 0:30H

    Reg. AA1234DD,         Date 23-may-22,         Time of use: 1:30H,         Accumulated: 2:30H

    Reg. AA1234DD,         Date 2-jun-22,             Time of use: 0:25H,         Accumulated: 2:55H

    Reg. ZZ4567GG,         Date 12-july-22,           Time of use: 1:30H,         Accumulated: 2:00H

    etc...

     

    Thanks.

    • Fred
    • 2 yrs ago
    • Reported - view
    raisla67 said:
    data types are:
    Date for Date
    Time for Time of use
    Text for Registration

     Don't know if it is too late, but may I recommend using a number field for Time. It looks like you only track hours. The Time field is used to keep track of actual time not the number of hours.

    To make a running total you can look at this post for some options and limitations.

    Something else to think about is using Dashboard to look at your data instead of trying to do summary fields in your raw data tables.

      • raisla67
      • 2 yrs ago
      • Reported - view

      Fred Thanks Fred.

      Could you recommend me a book to learn programming for Ninox?

      At least any similar language.

    • Fred
    • 2 yrs ago
    • Reported - view
    raisla67 said:
    Could you recommend me a book to learn programming for Ninox?

    Sadly, there isn't a book about Ninox programming.

    I found these videos very helpful. Look for the Ninox Learning videos.

    You can also check out the Webinars from Ninox, click on the Webinar link above.

    • Mel_Charles
    • 2 yrs ago
    • Reported - view

    Load of excellent videos from Nioxus on youtube!

    • Ninox partner
    • RoSoft_Steven.1
    • 2 yrs ago
    • Reported - view

    May I also suggest folowing videos

    Ninox recently adds new videos from time to time.

    • Rafael Sanchis
    • Rafael_Sanchis
    • 2 yrs ago
    • Reported - view

    95% of learning is with the questions that you Fred Mel Charles RoSoft_Steven  and other guys solved here. 👋

Login to reply

Content aside

  • 2 yrs agoLast active
  • 9Replies
  • 126Views
  • 5 Following