Caculate time difference between two DateTime variables

[JackALope]

Hi All!

I have startTime and an endTime as DateTime variable that looks like 2019-12-02 08:00:00 and 2019-12-02 11:45:00. I want to calculate the hours and minutes so it results in a String and look like: 3.75.

Thank you!

[kommijeevan (Jeevan Kommi)]

Hi @JackALope

use below code

(DateTime.ParseExact("12/30/1899 18:00:00", "MM/dd/yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture)-DateTime.ParseExact("12/30/1899 08:30:00", "MM/dd/yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture)).TotalHours.ToString()

Regards,
Kommi Jeevan.

[kadiravan_kalidoss (Kadiravan K)]

@JackALope

2019-12-02 11:45:00

Get the hours difference in time

Hi, I have two string such as 12/30/1899 08:30:00 [image] I need to find the hour differences between those 2 variable(both are generic value). Any suggestions? I tried few but didn’t work for me. Thank you xoxo

span.xaml (5.8 KB)

Thanks!

[sarathi125 (Parthasarathi)]

@JackALope,

Welcome to UiPath Community!.

Try like the following,

Convert.ToString( (DateTime.ParseExact("2019-12-02 08:00:0", "yyyy-MM-dd hh:mm:ss",System.Globalization.CultureInfo.InvariantCulture)-DateTime.ParseExact("2019-12-02 11:45:00", "yyyy-MM-dd hh:mm:ss",System.Globalization.CultureInfo.InvariantCulture)).Hours)

[gulshiyaa]

Hi @JackALope

just minus it
check this screen shot

Regards,
Gulshiyaa

[kommijeevan (Jeevan Kommi)]

I have create workflow based on requirement please check I hope you will get the solution.

Time Diff.xaml (4.7 KB)

[JackALope]

Thank you a lot! The thing is that I would like the minutes to be devided into hours, so if you have a time difference of 3 hours and 45 minutes, this should result in 3.75 instead of 3.45.

[Marti]

Try this:

[JackALope]

Thank you so much everyone!