WaqasTariq
Board Regular
- Joined
- Jun 26, 2012
- Messages
- 58
- Office Version
- 365
This may have a very simple answer, I have tried finding it, but in vain.
I have compounting minutes over a time frame. ex: 2,2,3,6,18,56,188,354,1547,2578,... 302380. If less than 1440 is Monday, >10080 and <=11520 is also Monday.
How do I do this in Excel?
I have compounting minutes over a time frame. ex: 2,2,3,6,18,56,188,354,1547,2578,... 302380. If less than 1440 is Monday, >10080 and <=11520 is also Monday.
How do I do this in Excel?
Minutes | Day Name |
4.00 | Monday |
7.00 | Monday |
9.00 | Monday |
1441 | Tuesday |
2567 | Tuesday |
5860 | Friday |
9481 | Sunday |
11432 | Monday |
11620 | Tuesday |