7 Replies Latest reply on Dec 5, 2018 10:58 AM by Vladimir Khvan

# Date Time Difference in Minutes

I have the following data

Start DateTime ,EndDate Time
how to calculate Difference in Minutes

For example

Start DateTime = 2018-11-20 07:14:23.013

End DateTime = 2018-11-20 08:14:23.013

Difference in Minutes = This thing i want to calculate

• ###### 1. Re: Date Time Difference in Minutes

try this:

DATEDIFF('minute', [Start DateTime], [End DateTime])

• ###### 2. Re: Date Time Difference in Minutes

is this correct difference ?

datediff('minute',[Start Time],[End Time])

I have used this formula

• ###### 4. Re: Date Time Difference in Minutes

I can share some sample of data

• ###### 6. Re: Date Time Difference in Minutes

StartDateTime                            ENDDATETIME

 2018-11-20 07:14:23.013 2018-11-20 07:14:23.013 2018-11-20 07:15:47.730 2018-11-20 07:15:47.730 2018-11-20 07:19:44.063 2018-11-20 07:19:44.063 2018-12-04 09:52:27.277 2018-12-04 09:52:27.277 2018-12-04 10:07:15.077 2018-12-04 10:07:15.077 2018-12-04 13:14:34.000 2018-12-04 13:14:34.000