Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
interval(EndTime-StartTime, 'mm')
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
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