Forum

Notifications
Clear all

maxifs problem

3 Posts
2 Users
0 Reactions
85 Views
(@usb)
Posts: 244
Honorable Member
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
(@purfleet)
Posts: 412
Reputable Member
 

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
(@usb)
Posts: 244
Honorable Member
Topic starter
 

Thank you for the professional and excellent answer !!

 
Posted : 09/01/2020 5:15 pm
Share: