-
Re: Can you use the TIME function to calculate the difference i.e. duration between values in 2 columns?
Give this a try (update column names to match your sheet): =INT((TIME(End@row) - TIME(Start@row)) * 24) + ":" + RIGHT("0" + (VALUE(RIGHT(End@row, 2)) - VALUE(RIGHT(Start@row, 2)) …1 · -
Re: February Question of the Month - Join the conversation and receive a badge
Badge Collector would be fun.2 · -
Re: How to incorporate HAS or CONTAIN in my Index/Match formula?
"Tile" would change to HAS(@cell, "Tile")1 · -
Re: Capabilities of "Viewers" in new Model
Viewers will not be able to edit or otherwise interact with (beyond viewing) any asset directly. To edit an asset, they would need to have access to one of the tools listed in your original comment. …1 · -
Re: JOIN only if cell is not blank
@PeggyLang =JOIN(COLLECT(Name:Name, [EVEN MTH WK1 TOC]:[EVEN MTH WK1 TOC], @cell <> ""), "delimiter of choice")1 ·