| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time function problem
Dear All, If value in cell A1------8:30 AM and B3 9:30 AM so i want time 8 am to 9 am than Zee network, if 9 to 10 than History. How it is possible please revert. Rgds Thakur |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time function problem
On Wed, 15 Feb 2012 04:22:57 -0800 (PST), upender thakur wrote:
Dear All, If value in cell A1------8:30 AM and B3 9:30 AM so i want time 8 am to 9 am than Zee network, if 9 to 10 than History. How it is possible please revert. Rgds Thakur perhaps something like: =choose(hour(a1)-7,"Zee network","History") Also, look at HELP for the CHOOSE function. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| verify use of TIME Function, Find Quantity Level compare to time-d | Excel Discussion (Misc queries) | |||
| first time he IF function problem | Excel Discussion (Misc queries) | |||
| Time Function Problem | Excel Worksheet Functions | |||
| More time questions and IF function problem | Excel Worksheet Functions | |||
| Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? | Excel Programming | |||
Linear Mode
