Jump to content
  • 0

Input time as minutes and decimal


JustAnotherLogin
 Share

Question

I am attempting to create several tables and with datapages inputs that will require to have 12 time fields (mm and secs) . The javascript DATE/TIME solution does not appear to practical. I was wondering if there is a way to do each time in two fields with one as whole minutes and the second being whole seconds. Could there be a javascript to change the whole seconds in to a decimal of a minute  (x/60) in the caspio table data?

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0
3 hours ago, JustAnotherLogin said:

I am attempting to create several tables and with datapages inputs that will require to have 12 time fields (mm and secs) . The javascript DATE/TIME solution does not appear to practical. I was wondering if there is a way to do each time in two fields with one as whole minutes and the second being whole seconds. Could there be a javascript to change the whole seconds in to a decimal of a minute  (x/60) in the caspio table data?

What exactly do you want to do?
Do you want the minute and seconds combined upon Submission, or they're just in separate fields?

What do you mean by converting seconds into minutes, why do you want to do this? Do you want to add this to the minute field, and have like one field for combined Minute and Seconds?

You can probably do both of these using Calculated Values. Basically, you'll use Virtual Fields to get the input for minutes and seconds, then, you'll set the actual fields as Calculated Values. You can combine the Minutes and seconds there through simple math
https://howto.caspio.com/datapages/datapage-components/calculated-values/

Link to comment
Share on other sites

  • 0

We are attempting to collect manufacturing process information. A portion of that information is how long processes take. None take more than a few minutes and we would like to capture times for about a dozen steps in each table including minutes and seconds. In a report these time could be viewed individually or tabulated. 

ex. Step one (name) (size) (mm:ss) 

...

Step twelve (name) (size) (mm:ss)

The minutes and seconds do not have to be combined but I believe that totaling them could be easier if combined. That is the reason I thought the decimal version would be easier to tabulate.

Link to comment
Share on other sites

  • 0
39 minutes ago, JustAnotherLogin said:

We are attempting to collect manufacturing process information. A portion of that information is how long processes take. None take more than a few minutes and we would like to capture times for about a dozen steps in each table including minutes and seconds. In a report these time could be viewed individually or tabulated. 

ex. Step one (name) (size) (mm:ss) 

...

Step twelve (name) (size) (mm:ss)

The minutes and seconds do not have to be combined but I believe that totaling them could be easier if combined. That is the reason I thought the decimal version would be easier to tabulate.

Yeah, decimal version is much better for me, too. Is that time manually typed? Like Minute:   11   Seconds   30 . Like that?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...