I have a healthcare note I am working on. Thanks to these fourms, I have figured out how to calculate a total time from a Start and Stop time. My problem is calculating a total time from the list of total times. I can get a total but I need to account for the minutes rolling to hours when they are equal to or greater than 00:60 as they calculate.
Example : Total 1 00:30
Total 2 00:31
Total 3 01:00
is calculating to a total of: 01:61
instead of: 02:01
Thanks,
Bryan J.
Views
Replies
Total Likes
So change each time to minutes, add them all up then divide by 60. This will give you the number of hours and the remainder will be the number of minutes.
Make sense?
Paul
Views
Replies
Total Likes
Can I send you my form? I have already put in script to seperate hours and mins for calculation, but I am not sure how to change it and then get the format back into the total box correctly.
Bryan J.
Views
Replies
Total Likes
Views
Replies
Total Likes
Paul,
Thank you very much - it seems to be working now. One more thing, now that we have it working I noticed that you changed all the object types to text - can I get the total to display 01:02 like it was before with a pattern? What would the pattern be to allow for the leading zero at the beginning and the first number after the semi-colon?
Thank you again,
Bryan J.
Views
Replies
Total Likes
Dear Mr. Paul
I've a problem to create the script to calculate the total hours of travel and work.
I've tried to send an e-mail to your address liveCycle8@gmail.com with the form that I'm looking to creat
I hope the address is correct
I've one problem like I found in this forum
I try to explain better and enclosed my form.
This is the first question that I sent to a wrong forum
During the creation of some calculation form, I've apropble to calculate the total time in hour because if I insert for example
4 time 0.15 min the total should be 1 hour but the form write 0,60.
Can some one help me to set the script for have the correct visualization in hours ?
And this is the second explanation
I'm using CycleDesigne ES, and I try to explain better what I need, sorry in advance for my bad english
Today I've a day off and I can't enclosed image or the correct setting for the fields
What I need is to create some field to calculate the travel time and travel wrok for single or multiple days
Hours Travel from | Hours travel to | work in the morning | finish work in the morning | start work in the afternoom | finish travel afte
So for example the technician start is travel at 8.00 and arrive at 8.15 start work at 8,15 and finish at 12.30 start work at 13,30 and finish at 18.00 start travel at 18.00 and arrive at 18,15.
We calculate minimum 15 minutes, we never write 8,20
Suppose that the label are
VS1 = start travel
VA1 = travel arrive
VSR = start travel back
VAR = Travel arrive back
The same procedure is for the work in the morning and in the afternoon
If the sum of VS1 and VA1 is 15 and is the same for VRS and VAR the total is 0.30 and is correct but if I try to calculate the sum ot two days the sum is 0.60 and should be 1 hour
The following is what I looking to do
Giorno | Ore di viaggio andataTravel time to site | Ore di lavoro mattinoWork time morning | Ore di lavoro pomeriggioWork time afternoon | Ore di viaggio ritornoReturn travel time | Totale ore viaggio | Totale ore di lavoro | ||||
Day | dalle/from | alle/to | dalle/from | alle/to | dalle/from | alle/to | dalle/from | alle/to | Total travel time | Total work time |
1 |
| |||||||||
2 | ||||||||||
3 | ||||||||||
4 |
The calculation in Excel is
=SE((B19<>"")*(C19<>"")+(H19<>"")*(I19<>"");(I19-H19)+(C19-B19);"")
Views
Replies
Total Likes
Views
Likes
Replies