Hours Calculation result after excluding the Days

[SantoshKumar]

Hi,

 I need to Modify Hours Column in My table. 

Currently i have two Columns 1. Days 2. Hours as shown in the pic below.

Hours value at present is Total Hours  but my requirement is to get Hours Value if and only if Days value is zero.

ex: if day value is 1, Hours value should be zero.

if day value is zero, then only hours value should populate by excluding the days.

thanks

santosh

[v-frfei-msft · Accepted solution]

Hi @SantoshKumar,

Here we can use MOD function to work on it.

Hours = IF(Table1[Days]=1,0,MOD(DATEDIFF(Table1[StartTime],Table1[EndTime],HOUR),24))

Regards,

Frank

[SantoshKumar]

@v-frfei-msftThanks. your query solves one of my issue.

[Greg_Deckler]

Try:

Hours = 
IF([Days]>0,0,DATEDIFF...)

So, just plug in your formula for the FALSE condition.

[SantoshKumar]

Thanks @Greg_Deckler

i was able to get the details in sql when i providde my query as:  DateDiff(Hour,StartTrgTime,endTrgTime)%24

when it comes to PB_query  - i have below option 

DATEDIFF(BABugs[Days],BABugs[Hours],HOUR) and it results are zero but i need remainder as my result.

 could you help me on it.