ExcelBanter - Time function problem

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Time function problem (https://www.excelbanter.com/excel-worksheet-functions/394004-time-function-problem.html)

upender thakur

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

Ron Rosenfeld[_2_]

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.

All times are GMT +1. The time now is 10:36 PM.