Help with time calculations where T=15mins?
 

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

Help with time calculations where T=15mins?
 

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

Help with time calculations where T=15mins?
 

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


.