Sum time

[mitjap]

hey,

problem:

00:20:03

00:50:00

12:50:43

1:20:15

I have used Sum([myfield]) and tryed most of solution on forum but its just not working for me. i have at least 200 different times to calculate. im new, but i try hard.

thank you.

[Anil_Babu_Samineni]

What is the purpose to have sum for time?

[mitjap]

machines have orders to do. every order have MRP demands including time. i would like to calculate how much time i need to finish orders on machine and how much HR i need.

Im stuck at "sum time". 

dont ask about how i will do in future, but i have good idea how to calculate all, what i need.

I solved easy apps and i need to do good coz i need this for future.

[Anil_Babu_Samineni]

From above 4 lines what is the output? Simply sum() won't work here. 

[mitjap]

i gave just example of numbers (there is a lot in my table), cant get screen shot up.

ye, i know it might not work so simple. but i like design of program and i wanna usit in future so im looking for help 🙂

[Anil_Babu_Samineni]

I agree. If you can share the output for 1 or 2 rows it should work for other rows as well..

[mitjap]

i like you. you gave me the idea. i checked again all my data i feel now like its new year.

i will do the math all in seconds and im saved.

Thank you.