The Math column can now do math with date/times. In particular: Subtracting two date/times produces a duration, which is a number and is measured in days, like in Google Sheets. Adding a duration (number) to a date/time, or subtracting it from a date/time will add/subtract that many days to it. Y…

[Proposal 2021-01-15 at 8.19.53 PM] [Proposal 2021-01-15 at 8.20.35 PM] on second row is 59 min but is only 58.56 only first row is working good

Maybe I’m confused at what I’m looking at. How is the 58.56 seconds supposed to be affecting the minutes column. I guess what I’m getting at is why is it seconds in a duration so closely matches minutes other than being a highly unlikely coincidence. Or am I just overthinking it and currently the…

ok, i fixed formula to: floor((((now - time in)*24)-floor(((now - time in)*24)))*60) and is working good now, tnx for helping

so i created nice tab “Time Card” using math column and Now function E-store Online bidding App

Hey guys how would I be able to display X number of hours and X number of minutes? (1hr & 5 minutes) See screenshot… [image]

[image] Time duration not presenting correctly in glide chart stopwatch Ask for Help I took it a step further and included Days as well. You can exclude it if you don’t need it. It’s a little involved, but I’ll explain the best I can. Here is my results: [image] Firs…

Thank-you @Jeff_Hager …so now the final question is… Why is the minute column doing what it is? It should be 5 minutes…? [image]

Can you show the formula in your minutes column?

I used yours form the example…which would you care to see?

Hey, @Jeff_Hager did that help?

🆕 Date-time Math

General

Jeff_Hager March 16, 2021, 5:00pm 86

Topic		Replies	Views
Fun with Dates Project Showcase	156	7077	April 19, 2022
New computed column: Math General	96	6411	November 12, 2021
📅 Guide on Dates & Times Community Resources	22	1697	April 2, 2025
🗓 Month, Day, and Year Math Functions Ask for Help	47	3902	July 15, 2023
If then else with DATE Ask for Help	28	3344	May 25, 2022

🆕 Date-time Math

Related topics