Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I HAVE A TWO DECIMAL COLUMN AND STORING TIME IN IT. LIKE AS FOLLOWS.
COLUMN 1 COLUMN2
06:50 07.15
07:45 09.30
How i can find the difference between these two time columns
Column2-Column1
not work like that. following is my formula
time(interval(time1-Interval(time2-time3,'hh:mm'),'hh:mm'))
time format is 05:25 like that