Forum Discussion

Copper Contributor

Oct 02, 2019

Solved

excel logic

KINDLY HELP US FOR MAKE A FORMULA FOR TOTAL HOURS THAT FALL BETWEEN SPECIFIC TWO TIMES CONDITION IS "Night Hours COUNTED FROM 20:00 - 04:00 THEN" HOW TO CALCULATE NIGHT HOURS IF THERE IS AVAILABLE ...

Formulas and Functions

SergeiBaklan
Oct 02, 2019
BRIJESH_KUMAR_KUSHWAHA

For such sample

in F3

=IF( $C3<$D3, $B$1-MIN($B$1,$C3)+MAX($A$1,$D3)-$A$1, MOD( MIN($D3,$B$1)-MAX($C3,$A$1),1) )
Night Hours.xlsx18 KB

BRIJESH_KUMAR_KUSHWAHA

Copper Contributor

Oct 02, 2019

SergeiBaklan THERE IS CONDITION THAT NIGHT HOURS IS TREATED FROM 20:00 TO 04:00 HOW TO CALCULATION NIGHT HOURS BETWEEN TIME IN AND TIME OUT DATA

IngeborgHawighorst

MVP

Oct 02, 2019

BRIJESH_KUMAR_KUSHWAHA Can you please find the Caps Lock key on your keyboard and turn it off? Writing in all upper case on the internet is perceived as SHOUTING and considered impolite.

SergeiBaklan
Diamond Contributor
Oct 02, 2019
IngeborgHawighorst , thank you

BRIJESH_KUMAR_KUSHWAHA , please check TechComm Code of Conduct https://techcommunity.microsoft.com/t5/Community-Guidelines/Microsoft-Tech-Community-Code-of-Conduct/m-p/31390, DON'T section (Don't: Use crazy fonts, profanity or ALL CAPS. All caps and strange fonts are annoying.)
- BRIJESH_KUMAR_KUSHWAHA
  Copper Contributor
  Oct 03, 2019
  Sorry for CAP Lock letter my English is very weak
  and also thanks for solving my problem SergeiBaklan