Find time difference between 2 dates

[hsendel]

Dears,

I need to find time difference between 2 dates with the format :

INPUT :
dd.MM.yyyy HH:MM:SS → This is the Format I have in Excel Sheet in one 2 Columns Representing Dates ( Date 1 & Date 2 )

OUTPUT:
dDys hHrs mMins sSec → This is the Format I need to have at the end after subtracting Date2 from Date1 )

Thanks in advance

[Palaniyappan (Palaniyappan P)]

Hi

Did we check with this thread

Change date format and keep times

Great so the expression be like this for different scenarios date_start = Datetime.ParseExact(StartDate.ToString,“dd/MM/yyyy hh:mm:ss”,System.Globalization.CultureInfo.InvariantCulture) date_finish = Datetime.ParseExact(StartDate.ToString,“dd/MM/yyyy hh:mm:ss”,System.Globalization.CultureInfo.InvariantCulture) date_start and date_finish is a variable of type System.Datetime nw for day difference int_date = (date_start-date_finish).TotalDays for minutes difference int_minutes = (date_sta…

We can combine all those individual conversion and concatenate the string with space in the middle so that you get the expected output format

Cheers @hsendel

[hsendel]

Thanks a lot @Palaniyappan for usual support, Indeed I cross such info previously, I just didn’t find it now

[Palaniyappan (Palaniyappan P)]

Glad it got resolved

@hsendel

[hsendel]

I’ve opened new topic where I need to color rows text based on one condition, I use “Change formatting” but it takes too much time

Quickest way to change formatting of rows based on condition

Dears, I need to color rows text based on one condition, I use Change formatting activity but it takes too much time for each row, is there any alternative option to make execution faster ? [tugna] Thanks in advance