Forum Discussion

Brass Contributor

Aug 13, 2022

Solved

USE IF Function in Ecel for Time

Hi Guys i want to read the Time (in 24h Formatting) out of a cell (Example = 12:25:36) I want to check if the Time is betw. 23:00 and 07:00. if so write NIGHT and if not DAY i use =WE...

excel

Formulas and Functions

HansVogelaar
Aug 13, 2022
PaddyB

Perhaps

=WENN(UND(STUNDE(D2)>6;STUNDE(D2)<23);"TAG";"NACHT")

HansVogelaar

MVP

Aug 13, 2022

PaddyB

Perhaps

=WENN(UND(STUNDE(D2)>6;STUNDE(D2)<23);"TAG";"NACHT")

PaddyB

Brass Contributor

Aug 13, 2022

heureka 🙂 was looking too long, did not see it 🙂 thanks for it