How to calculate time difference

[abbasaif]

Hi,

I want to calculate time difference in minutes as follows:

a=DATETIME() && {13/01/2020 02:38:15PM}
b={13/01/2020 02:19:15PM}
c=a-b

The answer is 20 minutes, and the value of "c" is 1116.

Please suggest.

Thanks

Abbassaif

 

[Mike Lewis]

Simply subtract one datetime from the other. That will give you the difference in seconds. To get the difference in minutes, divide by 60.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[Mike Lewis]

By the way, [tt]{13/01/2020 02:19:15PM}[/tt] is not a valid format for a datetime literal. You want this: [tt]{^2020-01-13,02:19:15}[/tt]

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads