I'm working with a column that has a duration in the format hh:mm:ss. How can I calculate the number of minutes, with a minimum of one? So
00:00:30 = 1 ,
00:01:20 = 2 and so on?
Time is a decimal portion of the day, use this: