Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two date fields in mm/dd/yyyy hh:mi:ss PM format.......
I want to caluculate the difference in same format........
I am using interval function
interval
(StartDate-Enddate, 'dd hh:mi:ss' )I am getting result as dd hh:mm:ss
But in minutes place I am getting mi(i).....
How to eliminate i and get exact minutes.......
I got it....I changed Number format to Interval and changed Pattern......Thanks
I got it....I changed Number format to Interval and changed Pattern......Thanks