| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time calculations for Scheduled vs Actual Employee Time and Wages | Excel Discussion (Misc queries) | |||
| Time calculations for Scheduled Time vs. Actual Time Worked | Excel Discussion (Misc queries) | |||
| how to round to the nearest 15mins | Excel Discussion (Misc queries) | |||
| Time difference calculations, daylight savings time, Excel | Excel Discussion (Misc queries) | |||
| convert time imported as text to time format for calculations | Excel Worksheet Functions | |||
![Johnny[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
