Calculating a Time Total from a list of Time Totals

[bjohnson17]

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.

[Former Community Member]

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

[bjohnson17]

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.

[Former Community Member]

Sure .....liveCycle8@gmail.com

Include a description of what you need.

paul

[bjohnson17]

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. 

[Dario_Carena]

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);"")