How to calculate time durations for Star time and End time Difference durations.
for Example Strar Time 10.00AM and End Time 12.00AM.
Thanks&Regs
Manavalan.A
Loading
Next live · Nov 23–27, 202651days to go
AI Agents Conference 2026
Virtual. Every session is recorded and published here on CSharp TV.
Leaderboard · last 7 days
Top earners
Mahesh Chand1 article · 1 news post+129pts2
Deepak Tewatia1 day visited+1ptsFull leaderboard →Answer a question in the forums and earn +2 points for every reply.
Ask a question
Jignesh TrivediPosted Feb 29, 2012, 7:37 AM
for C#, Try this.
DateTime time1 = DateTime.ParseExact("23:25:52", "HH:mm:ss", new DateTimeFormatInfo());
DateTime time2 = DateTime.ParseExact("13:15:16", "HH:mm:ss", new DateTimeFormatInfo());
TimeSpan Difftime = time1.Subtract(time2);
for SQL, try..
use DateDiff function but it vary difficult to get in HH:SS format.
SELECT DATEDIFF(hour, '2005-12-31 22:59:59.9999999', '2005-12-31 23:50:00.0000000');
SELECT DATEDIFF(minute, '2005-12-31 22:59:59.9999999', '2005-12-31 23:50:00.0000000');
SELECT DATEDIFF(second, '2005-12-31 22:59:59.9999999', '2005-12-31 23:50:00.0000000');
hope this help