Notifications
Clear all
Topic starter
hi
In the attachment, I need to get every employee every first time and last departure time
In column C D, I split column E into a separate date and time
In cell I2 I wrote MAXIFS formula but the result is 0 why?
thank you!!
lea
Posted : 09/01/2020 2:00 pm
Doing =RIGHT(E5,8) on column E is not returning the time in a format excel can recognise. Try =TIME(HOUR(E5),MINUTE(E5),SECOND(E5)) and your maxifs works
Posted : 09/01/2020 3:38 pm
Topic starter
Thank you for the professional and excellent answer !!
Posted : 09/01/2020 5:15 pm