Need Assistance Adding up Time in HH:MM:SS format

G

GATORWOMAN48

New member
Joined
Jan 21, 2020
Messages
4
Reaction score
0
Points
0
Excel Version(s)
Excel 2016
I am in a metrics based position where the tickets I work are timed for how long I am in there and it is in HH:MM:SS format. So if I was in a ticket for 1 hr 15 mins 2 seconds obviously the report would read 01:15:02 as an example. I want to take the column and add up that "time spent in ticket" however when I use the sum formula it will not work. I am trying to verify that the reports for each category I do are correct as I believe that they are not. Any help is appreciated.
 
.
Here's the first thing I located :

Code: 
Option Explicit

Sub AddHHMMSS()
'' SUM time in Column
'' Choose Column,StartRow,EndRow
'' result will be placed at Column:EndRow + 1
'' Column=1  1=A,2=B, ...
Dim i As Long
Dim w As Worksheet
Set w = ActiveWorkbook.Worksheets(1) ''choose first worksheet


Dim d As Double
Dim Column, StartRow, EndRow As Integer


Column = 1 ''this is A Column
StartRow = 1
EndRow = 25


For i = StartRow To EndRow
    d = d + CDate(w.Cells(i, Column)) * 24 * 60 * 60
Next


''convert seconds to days


d = d / 86400#
''display result in EndRow+1
w.Cells(EndRow + 1, Column) = Format(d, "hh:mm:ss")
End Sub

Here's another in formula : https://www.consultdmw.com/excel-summing-time.html
 
Perhaps post a sample sheet? Is your time real time or text looking like time?
 
You must log in or register to reply here.
Back
Top