In the math column type, configuration field; I attempt to put in max(s1,s2) - min(s3,s4) where s1/s2 are two end dates and s3/s4 are two start dates. I need to be able to calculate the time in minutes between the two values but it doesn’t seem like this logic is easy for Glide to perform.
You could use two IF columns to determine and return the min start date and the max end date. Then use a math column to calculate the difference between the two IF column dates and convert to minutes. (D1-D2)*1440
2 Likes
Hi Jeff,
Yes, I have a workaround in place, but it just seems silly when there is tooling to insert Excel formulas and use Min/Max in the Math column within Glide that it can’t do something this simple here. In order to get this to work I had to create two array columns, one for the start times and one for the end times, and then calculate the Min and Max in separate Rollup Columns, and then create a fifth column to calculate the difference.
1 Like
Not discounting your request, but my solution would cut it down to 3 columns. If you want a one column solution, you could use a javascript column. Not great if you are trying to get a date out of it, but since you are just looking for a number (minutes), then it should work fine.
1 Like
Jeff,
I looked at the Javascript column as well. My understanding is that all of the columns in experimental are subject to change. This function is critical to the app that i’m building so i’m hesitant to use a feature that may be dropped. Your if/then solution makes sense though. I’ll give that a shot with the next set of max/mins that I need to figure out.