J
Johnny
Hi all,
Sorry to bother you again, but I need to know how this
solution was worked out; i.e. how 96 equates to 15
minutes, and how I can change it to read 2 minutes in
another column..
Hoping someone can help,
Johnny
Just what I needed!
Many thanks Harald.
Johnny
Sorry to bother you again, but I need to know how this
solution was worked out; i.e. how 96 equates to 15
minutes, and how I can change it to read 2 minutes in
another column..
Hoping someone can help,
Johnny
Just what I needed!
Many thanks Harald.
Johnny
..-----Original Message-----
Hi Johnny
=COUNTIF(A1:A1000,"T")/96
format result cell as time hh:mm
HTH. Best wishes Harald
.