Visual Basic

dcof wrote:

connectionString="TestI; Database=OPS; User ID=Usr; Password=etxxxxxx;"

Dim sDateFrom As String
                       Dim sDateTo As String

                       sDateFrom = CStr(row.Cells(3).FormattedValue)
                       sDateTo = CStr(row.Cells(4).FormattedValue)

                       If DateTime.TryParse(sDateFrom, dfrom) AndAlso DateTime.TryParse(sDateTo, dto) Then
                           tHrs = dto - dfrom

                           Dim hr As Integer = tHrs.Hours
                           Dim min As Integer = tHrs.Minutes
                           Dim sec As Integer = tHrs.Seconds

                           Dim timediff As String = ((hr.ToString("00") & ":") + min.ToString("00") & ":") + sec.ToString("00")

dto = row.Cells(3).Value
dFrom = row.Cells(4).Value

result = dto - dfrom

Console.WriteLine("{0}", result))

DateTime start = new DateTime(2016, 3, 14, 8, 45, 0);
DateTime end = new DateTime(2016, 3, 14, 11, 6, 0);
TimeSpan diff = end - start;
Console.WriteLine("TimeSpan is {0} hours and {1} minutes", diff.Hours, diff.Minutes);

namespace ConsoleApplication12
{
    class Program
    {
        static void Main(string[] args)
        {
            DateTime date1 = new DateTime(year: 2491, month: 5, day: 1, hour: 0, minute: 0, second: 5);
            DateTime date2 = new DateTime(year: 2491, month: 5, day: 1, hour: 17, minute: 15, second: 3);
            TimeSpan ts = date1 - date2;
            Console.WriteLine(ts.ToString());
            Console.WriteLine(string.Format("The bomb will explode in {0:%h} hours, {0:%m} minutes and {0:%s} seconds.", ts));
            Console.ReadKey();
        }
    }
}

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Console.WriteLine("The bomb will explode now.")