| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula for counting minute intervals
I need help creating a formula! I have to keep track of my time and it goes
by minutes. If there is no activity after 7 minutes, the system assumes I've taken a break. From the system I'm able to copy my time and paste it into an excel sheet. For instance, these are my times this morning: 10:29:00 AM 10:31:00 AM 10:31:00 AM 10:32:00 AM 10:32:00 AM 10:32:00 AM 10:37:00 AM 10:37:00 AM 10:40:00 AM 10:52:00 AM 10:52:00 AM 11:16:00 AM 11:16:00 AM In the next column, I want to have a formula that counts the minutes that have passed and if there is a break (7 minute interval) mark the cell red or yellow. Thank you in advance for any assistance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change cell font color if time is by 15 minute intervals upto 2h | Excel Discussion (Misc queries) | |||
| Change cell font color if time is by 15 minute intervals upto 2hr | Excel Worksheet Functions | |||
| How do I calculate spreadsheet at five minute intervals | Excel Discussion (Misc queries) | |||
| I want my X axis to have 5-10 minute intervals | Charts and Charting in Excel | |||
| Counting cells with intervals | Excel Worksheet Functions | |||
Threaded Mode
