Forum Discussion
- PeterBartholomew1Silver Contributor
=LET( clockin, IFERROR(MOD(TEXTBEFORE(clockData, "-"), 1), "Off"), clockout, MOD(TEXTAFTER(clockData, "-"), 1), adjusted, N(clockout < clockin), IFERROR( HSTACK( name, clockin, (timeline >= clockin) * (timeline <= clockout + adjusted) ), "" ) )
giving
- NightstrandCopper Contributor
Thank you for looking at this for me, I'll put your code into my spreadsheet and see if I can get it working
- PeterBartholomew1Silver Contributor