cancel
Showing results for
Did you mean:
Member

## 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)

Any Ideas?

2 ACCEPTED SOLUTIONS

Accepted Solutions
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.

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
2 REPLIES 2
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.

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

Announcements

#### 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

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

#### Power Platform World Tour

Find out where you can attend!

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