Solved: Adding time to time - Page 2

DC81 · 06-20-2021 01:48 AM

I would’ve thought this one to be so simple but yet i am pulling my hair out. This is nothing like a spreadsheet…

I need a virtual column to determine wether a time (set via a time picker on my form) is less than (or greater than) a set time (10:30am) and change it’s own value to either 0 or 1 accordingly. This would be a trigger to deduct 15mins from a work day.

In total, I actually need to determine wether a time frame crosses a break of 15mins which starts at 10:30am (and then lunch and afternoon tea)

Any ideas or samples would be greatly appreciated.

Thanks in advance

Dan

Suvrutt_Gurjar

You are welcome. There are functions as below that basically convert duration into decimals. With some workarounds as below, these could be deployed for time calculations in decimals.

So TOTALHOURS(“12:00:00 PM”-“00:00:00”)/24 will give 0.50 for 12 PM

TOTALHOURS(“06:00:00 AM”-“00:00:00”)/24 will give 0.25 for 6 AM

TOTALHOURS(“12:00:00 AM”-“00:00:00”)/24 will give 0.00 for 12 AM

In all the expressions above the first parameter is time.

There is also TOTALSECONDS() available.

View solution in original post