I’m trying to create a formula column called “Duration” that minuses a column called “Start Time” from the “End Time” column. Unfortunately, the result is either a full number or a blank if it’s less than 1. Is this a normal feature or a glitch?

Was this ever solved? I’d like to know the same thing. I can use HOURS_DIFF to produce a duration in HH:MM (eg 00:30 or 00:10). But I’d like to convert those numbers to decimal (ie 0.5 or 0.166).

Say your difference is 01:30 (i.e. 1.5 hours), it takes that text and changes 01:30 to 1.3 (SUBSTITUE), then does 1.3 - 1 (ROUNDDOWN) which gives you the 0.3. Now that you have 0.3 you do 0.6 divided 0.3 (DIVIDE) to get the percentage, 0.5, then you “sum” back the 1.0 (SUBSTITUTE again) to the 0.5 giving you 1.5.

Essentially, Monday seems to be ok with working with numbers extracted from text, so once you know that, you can probably come up with other ways (and possible shorter formulas) to get what you need.