[Akash Maheshwari]

Hi Team,

Require a formula for the following situation:

CELL A1 contains a Time
CELL B1 contains a Writeup as Morning Report / Afternoon Report / Evening Report.

if Cell A1 is equal or between 12:00AM to 11:59 AM then CELL B1 should display Morning Report

if Cell A1 is equaly or between 12:00PM to 17:59 PM then CELL B1 should display Afternoon Report

if Cell A1 is equaly or between 18:00PM to 23:59 PM then CELL B1 should display Evening Report

Pls help how to cope up with this.

Pls guide.

Rgds

Akash Maheshwari

[Claus Busch]

Hi Akash,

Am Thu, 26 Nov 2015 09:38:38 -0800 (PST) schrieb Akash Maheshwari:

if Cell A1 is equal or between 12:00AM to 11:59 AM then CELL B1 should display Morning Report

if Cell A1 is equaly or between 12:00PM to 17:59 PM then CELL B1 should display Afternoon Report

if Cell A1 is equaly or between 18:00PM to 23:59 PM then CELL B1 should display Evening Report

try:
=IF(A1<TIME(12,,),"Morning Report",IF(A1<TIME(18,,),"Afternoon Report",IF(A1=TIME(18,,),"Evening Report","")))


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

[Akash Maheshwari]

Hello Mr. Claus B.,

Thanx for your support.

Although Its working fine but Afternoon Status is only between 12:00hr till 13:00hrs. As soon as it crosses 13:00 hrs the status changed to Evening Report.

Pls help in resolving the same.

Rgds

Akash Maheshwari



On Thursday, November 26, 2015 at 11:22:32 PM UTC+5:30, Claus Busch wrote:
Hi Akash,

Am Thu, 26 Nov 2015 09:38:38 -0800 (PST) schrieb Akash Maheshwari:

if Cell A1 is equal or between 12:00AM to 11:59 AM then CELL B1 should display Morning Report

if Cell A1 is equaly or between 12:00PM to 17:59 PM then CELL B1 should display Afternoon Report

if Cell A1 is equaly or between 18:00PM to 23:59 PM then CELL B1 should display Evening Report

try:
=IF(A1<TIME(12,,),"Morning Report",IF(A1<TIME(18,,),"Afternoon Report",IF(A1=TIME(18,,),"Evening Report","")))


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

[Claus Busch]

Hi Akash,

Am Thu, 26 Nov 2015 10:10:43 -0800 (PST) schrieb Akash Maheshwari:

Although Its working fine but Afternoon Status is only between 12:00hr till 13:00hrs. As soon as it crosses 13:00 hrs the status changed to Evening Report.

please check your times. Here I have Afternoon Report from 12:00 until
17:59.
Do you have dates in the time cell?
If you can't get it to work please send an example workbook to
claus_busch(at)t-online.de


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

[Claus Busch]

Hi,

Am Thu, 26 Nov 2015 10:10:43 -0800 (PST) schrieb Akash Maheshwari:

Although Its working fine but Afternoon Status is only between 12:00hr till 13:00hrs. As soon as it crosses 13:00 hrs the status changed to Evening Report.

try:
=IF(MOD(A1,1)<TIME(12,,),"Morning Report",IF(MOD(A1,1)<TIME(18,,),"Afternoon Report",IF(MOD(A1,1)=TIME(18,,),"Evening Report","")))


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

[Akash Maheshwari]

Dear Mr. Claus B.

Sorry to say but I would like to inform that its Not Working.

Rgds

Akash Maheshwari


On Thursday, November 26, 2015 at 11:53:01 PM UTC+5:30, Claus Busch wrote:
Hi,

Am Thu, 26 Nov 2015 10:10:43 -0800 (PST) schrieb Akash Maheshwari:

Although Its working fine but Afternoon Status is only between 12:00hr till 13:00hrs. As soon as it crosses 13:00 hrs the status changed to Evening Report.

try:
=IF(MOD(A1,1)<TIME(12,,),"Morning Report",IF(MOD(A1,1)<TIME(18,,),"Afternoon Report",IF(MOD(A1,1)=TIME(18,,),"Evening Report","")))


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

[Mandeep Baluja]

=IF(A1<=TIME(12,0,0),"Morning Report",IF(A1<=TIME(13,0,0),"Afternoon Report","Evening Report"))

check this out !!!

1) in starting you have written if Cell A1 is equaly or between 12:00PM to 17:59 PM then CELL B1 should display Afternoon Report
2) Then you wrote Afternoon Status is only between 12:00hr till 13:00hrs.

Please stick to one parameter only

Regards,
mandeep baluja