Adding Time

[Jeff88]

Good Day,

I've been checking some solution by it seems that its not working on my end. Is there a way to add multiple time in time format (HH:MM:SS)?

Break	Lunch	Coaching	Training	Meeting	Hold	Avail	SUM of All
2:05:15	8:32:20	3:05:11	10:05:15	2:33:15	00:05:02	03:02:22

Thank you,

[Robin_McIntosh]

What are you trying to add up?  Duration between each activity?  Are the values below actual times or lenght of the activity?

[Jeff88]

Hi Robin,

It's the length of activity. I just want to add the total time.

For Ex.  (Coaching) 1:03:05  +  (Meeting) 3:05:15 = 4:08:20   < this should be the result

Also just to add,

Is there also a way to divide the time and result in percentage, like in excel.

For Example

Total Time (5:25:08) / Actual Time (8:22:03)  = Result should be 64.76%

Thank you in advance

[binuacs]

@Jeff88 one way of doing this

[LouisJ]

I made it too but binuacs's method is a tiny bit more efficient haha

[Jeff88]

Thank you so much, will check

Is there a way to divide the time? sorry i just edited my last question and add the question to it

[Jeff88]

Thank you,

One more thing please, i do have other columns that is not a time format. How do i show them after the result? I have Name, Supervisor and Site

[binuacs]

@Jeff88 Can you share a sample file with the given fields?

[LouisJ]

My take on dividing (convert times to second and then divide) :

[binuacs · Accepted solution]

@Jeff88 adding additional names like name supervisor etc