IF function on Time

[Shinianne]

Hi can I please ask for help is it possible to use IF to Time?


If its between 08:00 - 15:59 CST time it will be AMER
If its between 16:00 - 23:59 CST Time APAC
If its between 00:00 - 07:59 CST Time EMEA


I tried =IF(AB2<TIME(15,59,0),"AMER",IF(AB2<TIME(23,59,0),"APAC",IF(AB2<TIME(7,59,0),"EMEA")))


and its not working

 

[AlanY]

if your time in A1, try

=IF(A1>=TIME(16,0,0),"AMER",IF(A1>=TIME(8,0,0),"APAC","EMEA"))

 

[Shinianne]

if your time in A1, try

=IF(A1>=TIME(16,0,0),"AMER",IF(A1>=TIME(8,0,0),"APAC","EMEA"))

Hi I tried it but its not falling on the criteria,

Time	REGION
04:27:01	AMER
04:23:46	AMER
03:36:45	AMER
03:17:53	AMER

<colgroup><col><col></colgroup><tbody>
</tbody>

Its showing AMER on 4:00:00 CST which should show as EMEA

 

[AlanY]

works for me

Book1
	A	B
1	Time	REGION
2	04:27:01	EMEA
3	04:23:46	EMEA
4	09:36:45	APAC
5	23:17:53	AMER
Sheet1

Cell Formulas
Range	Formula
B2	=IF(A2>=TIME(16,0,0),"AMER",IF(A2>=TIME(8,0,0),"APAC","EMEA"))

 

[Shinianne]

works for me

	A	B
1	Time	REGION
2	04:27:01	EMEA
3	04:23:46	EMEA
4	09:36:45	APAC
5	23:17:53	AMER

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula B2 =IF(A2>=TIME(16,0,0),"AMER",IF(A2>=TIME(8,0,0),"APAC","EMEA")) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

The formula for my time is =TEXT(L2,"HH:MM:SS") if i use the formula it wouldnt work for me ..

 

[FormR]

The formula for my time is =TEXT(L2,"HH:MM:SS") if i use the formula it wouldnt work for me ..

Hi, what exactly do you have in L2? If it's a date and time and the text() function is an attempt to extract just the time then use this formula instead and apply a number format of HH:MM:SS to display it the way want.

=MOD(L2,1)