(Livecycle) How calculate time in extensible table

Avatar

Avatar
Validate 1
Level 1
lindsayg9092203
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
lindsayg9092203
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
lindsayg9092203
Level 1

15-05-2015

Hy!

Sorry for my English. I need help.

I have a problem to find a simple script to calculate the time [HH:MM].

I have a table where the client can add many row.

The last column is for the total time per day.

Here's an example:

MondayPlaceKilo.Total Hours
+  -City1808:35
+  -other city305:05
+  -big city703:15
Totals28 km16:55

My question is how to calculate the big total time if he can add many row.

Thanks i'm very despair.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Level 4
jasotastic81
Level 4

Likes

35 likes

Total Posts

329 posts

Correct reply

43 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Level 4
jasotastic81
Level 4

Likes

35 likes

Total Posts

329 posts

Correct reply

43 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
jasotastic81
Level 4

22-05-2015

Answers (4)

Answers (4)

Avatar

Avatar
Validate 1
Level 1
lindsayg9092203
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
lindsayg9092203
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
lindsayg9092203
Level 1

22-05-2015

Thank you so much! it's Working

Avatar

Avatar
Validate 1
Level 1
lindsayg9092203
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
lindsayg9092203
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
lindsayg9092203
Level 1

21-05-2015

Hi!

I have tried your solution, but it does not work . I tried to remake a new file with the same table and information. But it still doesn't work.

I'm very nub in java-script, could you please send me your .PDF file so I could look at it?

So to answer to your question, the user put exactly the time he worked.

Example 2h15 (2:15) for the first job and he can add a row to an other job and add example 6h15 (6:15). The total of the day is 8h30 (8:30).

Thank you

Avatar

Avatar
Validate 1
Level 1
lindsayg9092203
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
lindsayg9092203
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
lindsayg9092203
Level 1

20-05-2015

Thank you for answer, I try this now.

Avatar

Avatar
Validate 1
Level 4
jasotastic81
Level 4

Likes

35 likes

Total Posts

329 posts

Correct reply

43 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Level 4
jasotastic81
Level 4

Likes

35 likes

Total Posts

329 posts

Correct reply

43 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
jasotastic81
Level 4

20-05-2015

I don't know where you're getting the Total Hours from, but if you're having the user type them into a text field, here's a solution that will work. (If not, perhaps you can modify it to match what you need.)

766020_pastedImage_0.png