Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

How to sum of HH:MM:SS

Home
Forums
Visual Basic .NET

How to sum of HH:MM:SS

Saurabh Suthar

7yAsked Jan 16, 2019, 11:24 PM1.9kVisual Basic .NET

Please suggest to me how to sum of HH:MM:SS for particular single ID. and in that id multiple data can save. So how toSum of all data duration and display in HH:MM:SS format.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Dhara Patel6y ago
hi,

Try bellow code:
Mageshwaran R6y ago
Hi,
Try this code:
TimeSpan s1 = TimeSpan.Parse("0:15");
TimeSpan s2 = TimeSpan.Parse("0:45");
TimeSpan s3 = s1 + s2;
Sreekanth Reddy7y ago
Hi Saurabh,

List emplst = _dbContext.Employees.where(x=>x.ID =1).ToList();
TimeSpan t1 = TimeSpan.Parse("00:00:00");
for(int i=0;i
{
TimeSpan t2 = TimeSpan.Parse(emplst[i].TimeIs.ToString());
t1 = t1.Add(t2);
}
//Now t1 contains total time.
Mark as answer, If it helps. Else come up with your query.
Thank you.
Sanwar Ranwa7y ago
Hello Saurabh

Please check this
CREATE TABLE Tblemp
(
ID INT,
EmpTime TIME

)
INSERT INTO Tblemp
VALUES
(1,'09:01:48'),
(1,'3:05:52'),
(1,'4:10:25'),
(1,'1:08:00'),
(2,'9:15:48'),
(2,'11:00:52'),
(2,'12:00:25'),
(2,'7:00:00'),
(3,'9:00:00'),
(3,'3:00:00')


select * from Tblemp

WITH CTE(e, mw) AS
(
    SELECT ID, SUM(DATEDIFF(MINUTE, '0:00:00', EmpTime))
    FROM Tblemp

    GROUP BY ID
)
SELECT ID = e,
  TotalTime = RTRIM(mw/60) + ':' + RIGHT('0' + RTRIM(mw%60),2)
  FROM CTE;