cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Condition With hours

Hello Everyone!

 

I need your help in calculating a column which give me either a 1 o 0, a 1 when in the column "HORA_INGRESO" is after 10:30 and the column "CD" is 1011, other wise the result wuld be 0.

I am usig this calculated column, and didnt work

HOUR = IF(CABECERAPEDIDOSAP[HORA_INGRESO]>"10:30" && CABECERAPEDIDOSAP[CD]="1011" ;1;0)

ddddd.PNG

Any Ideas?

 

Thanks for your help

2 ACCEPTED SOLUTIONS

Accepted Solutions
edhans Super Contributor
Super Contributor

Re: Condition With hours

Use the following formula for your calculated column:

 

IF(Times[Time]>TIME(10, 30, 0) && Times[CD]="1011",1,0)

 

You'll need to translate that to your column names, but the key is you are comparing your time column to the TIME() function. The && allows you to add additional comparisons to the IF() statement. 

View solution in original post

Super User
Super User

Re: Condition With hours

Hi,

 

Try this calculated column formula

 

=IF(AND(CABECERAPEDIDOSAP[HORA_INGRESO]>TIME(10,30,0);CABECERAPEDIDOSAP[CD]="1011");1;0)

 

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

2 REPLIES 2
edhans Super Contributor
Super Contributor

Re: Condition With hours

Use the following formula for your calculated column:

 

IF(Times[Time]>TIME(10, 30, 0) && Times[CD]="1011",1,0)

 

You'll need to translate that to your column names, but the key is you are comparing your time column to the TIME() function. The && allows you to add additional comparisons to the IF() statement. 

View solution in original post

Super User
Super User

Re: Condition With hours

Hi,

 

Try this calculated column formula

 

=IF(AND(CABECERAPEDIDOSAP[HORA_INGRESO]>TIME(10,30,0);CABECERAPEDIDOSAP[CD]="1011");1;0)

 

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

Helpful resources

Announcements
New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,799)