+ Start a Discussion
Daniel FerraraDaniel Ferrara 

Hour of the Day Formula 0 to 23 not working

This formula does not work for entire 24 hour clock in Pacific Time Zone.

CASE(MID ( TEXT (CreatedDate), 12, 2),"01",1," 02",2,"03",3,"04",4,"05",5,"06",6,"07",7,"08",8,"09",09,"10",10,"11",11,"12",12,"13",13,"14",14,"15",15,"16",16,"17",17,"18",18,"19",19,"20",20,"21",21,"22",22,"23",23,"00",00,Null)-(7)
Best Answer chosen by Daniel Ferrara
GulshanRajGulshanRaj
Hi Daniel,

Try this:
CASE(MID ( TEXT (CreatedDate), 12, 2),"01",18,"02",19,"03",20,"04",21,"05",22,"06",23,"07",0,"08",1,"09",2,"10",3,"11",4,"12",5,"13",6,"14",7,"15",8,"16",9,"17",10,"18",11,"19",12,"20",13,"21",14,"22",15,"23",16,"00",17,Null)

Please let me know if this will work. I trust it will.

Thanks
Gulshan Raj

All Answers

Neetu_BansalNeetu_Bansal
Hi Daniel,

Can you please let me know what is your requirement?

Thanks,
Neetu
GulshanRajGulshanRaj
Hi Daniel,

Try this:
CASE(MID ( TEXT (CreatedDate), 12, 2),"01",18,"02",19,"03",20,"04",21,"05",22,"06",23,"07",0,"08",1,"09",2,"10",3,"11",4,"12",5,"13",6,"14",7,"15",8,"16",9,"17",10,"18",11,"19",12,"20",13,"21",14,"22",15,"23",16,"00",17,Null)

Please let me know if this will work. I trust it will.

Thanks
Gulshan Raj
This was selected as the best answer
Daniel FerraraDaniel Ferrara
To have the Call Report Grouped by Call Hour. *Dan Ferrara* IT Manager 949-238-6623 | dferrara@capitalalliance.com | www.capitalalliance.com This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. This communication may represent the originator’s personal views and opinions, which do not necessarily reflect those of Capital Alliance Group. If you are not the original recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email in error, and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited.
Daniel FerraraDaniel Ferrara
That worked great "bahut atcha" Shukariya Gulshan *Dan Ferrara* IT Manager 949-238-6623 | dferrara@capitalalliance.com | www.capitalalliance.com This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. This communication may represent the originator’s personal views and opinions, which do not necessarily reflect those of Capital Alliance Group. If you are not the original recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email in error, and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited.
Daniel FerraraDaniel Ferrara
Thanks Gulshan, I am grateful for your help.
GulshanRajGulshanRaj
Most  welcome @Daniel