Calculate Time Difference

[Anonymous]

Hi,

I have a scenario like below,

StartTime     EndTime     

22:03:20       23:40:30     

23:45:33       00:12:30      

00:20:20       01:50:40      

I need to calculate the time difference between Start time and End Time.

Thanks in advance

Regards,

Leni

[Gysbert_Wassenaar]

interval(EndTime-StartTime, 'mm')

[Anonymous]

If I mention like 'mm' whether it will return the minute value alone?? If so, then my requirement is something different

Startime = 15:52:36

EndTime = 15:52:41

Time Diff = 00:00:04

With this time difference I need to calculate this time in minutes, by converting hour, minutes and seconds in minutes which will be 0.07 mins

Thanks,

Leni

[Gysbert_Wassenaar · Accepted solution]

no, the 'mm' means that the difference will be shown in minutes. If you use 'hh:mm:ss' it will show it in hours, minutes and seconds