To Harald Staff (or anyone who knows)
Johnny
There are 96 (15mins) in 24 hours
Neil
"Johnny" wrote in message
...
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
-----Original Message-----
Hi Johnny
=COUNTIF(A1:A1000,"T")/96
format result cell as time hh:mm
HTH. Best wishes Harald
"Johnny" skrev i melding
...
Hi all,
I'm wondering if someone can help me..
I'm looking for a way to have ticks in cells to
represent
15 minute chunks of time (I have a font that
replaces "T"
with a tick).
I would then like to sum these 15 minute chunks(ticks/T)
and format the result in hours and minutes at the bottom
of the column.
Any ideas, as I'm completely stumped!!
MTIA
Johnny
.
.
|