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


.

..

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


.

.

Hi Johhny,

Divide by 24 to return hours

Divide hours by 15 (your minute interval) returns 4
24 x 4 = 96, hence Harald's divisor.

-------------------------------------

Therefore, for your new 2 minute interval (using Harald's approach):
Divide by 24 to return hours

Divide hours by 2 (your minute interval) returns 30
24 x 30 = 720.

New formula:

=COUNTIF(A1:A1000,"T")/720

---
Regards,
Norman



"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


.

.

Many thanks gents.
I wonder if you guys realise how you save people's skins
daily.
Regular Superheroes!

Johnny

-----Original Message-----
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


.

.




.