Skip to main content

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?

Educational Brain Teaser : Graph of

Will not use column "D" as data source.

 

pastedImage_12.png

 

Thanks,

Shin

pastedImage_35.png
5 answers
  1. Feb 15, 2018, 9:32 PM

    Whoa-- this was fun, and I'm still working on it. I came close, but the process I used was quite messy:

    Whoa-- this was fun, and I'm still working on it.

    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!

0/9000