Time difference

01.09.2021 Enter Time (row 0 )

08:00:12
08:12:43
08:10:00
08:11:55
08:00:05
08:10:44

01.09.2021 Exist Time ( row 1)

18:13:11
18:13:11
17:13:14
17:13:10
17:12:45
17:13:26

ı want to diffrence time (exist time-enter time) Can u help me?

Hi

We can find with this expression

Datetime.Parse(your input 1) - Datetime.Parse(your input 2)

Cheers @sedayngl_sedayngl33

ınput 1 and ınput 2 it should be string am i right

That’s right
@sedayngl_sedayngl33

thank you :slight_smile:

is it require HH:mm:ss?

Well not exactly
Datetime.Parse can take the format on its own
Only for Datetime.ParseExact we need to mention the format

@sedayngl_sedayngl33

1 Like

the result what is type? string or datetime?

1 Like

@sedayngl_sedayngl33
when working with time portion we can do also:
grafik
And can do:
grafik
grafik

It will be of type TimeSpan

Use .ToString for string type
@sedayngl_sedayngl33

1 Like

What type is Cdate?

And can u show write line activity?

CDate means Convert.ToDate

And it can be written in writeline activity by including .ToString along your output

@sedayngl_sedayngl33

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.