Shin's EBT - #3
I found It's fun to have this communication.
Sometimes easy sometimes might be difficult.
This is Very simple excel replication request.
Sometimes, copying excel is ridiculous request, but this seems reasonable?
Will not use column "D" as data source.
Thanks,
Shin
Whoa-- this was fun, and I'm still working on it. I came close, but the process I used was quite messy:
I tried conventional time formatting (Hh:Nn Ss) but I couldn't get that to work I'm still not convinced that won't work-- I just may need a reminder of how to use it!
Eventually I decided to revisit an old friend-- Modulo! I used that to string together the individual time components, but it wasn't very pretty (in fact, I suspect most vizzer's worth their salt would take one look and groan, and immediate suggest if we could award NEGATIVE points).
Scrutiny will show that the seconds don't always match up-- guess I should use a ROUND rather than an INT statement there.
I'll keep plugging away!