View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Johnny[_8_] Johnny[_8_] is offline
external usenet poster
 
Posts: 2
Default 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