how do I take the hours and minutes from the date, by taking the hour the expected result is that if the employee checks in at the office later than 8 am then the status is late entering the office, if it is at 8 am or below 8 am, the employee will enter on time
Do you just want to use the hours and minutes for an IF condition?
If so, you could do something like this in a math column. It just concerts hour and minute into a number. It doesn’t necessarily represent the time, but should work just fine for an IF condition. So 8:30am would become 8.3.
HOUR(Date) +
MINUTE(Date)/100
2 Likes
thank you, it has been successfully implemented, one more question is how to take the month in an existing date and the results are in the form of text
1 Like
Do you mean that you want the Month name instead of a number?
yes, the name of the month, can that be done?
If it can’t be done, maybe I’ll use a number, and use if than else
Yes, I think using the number from MONTH(Date) and an IF column would be the easiest method. Other people have different methods with a few more steps, but I think the IF column is the simplest.
A Format Date column can do it too, but I feel like it can be unstable at times.
1 Like
OK, thank you, can I ask one more thing?
Can you determine from 06.00 to 11.00 in the morning, from 11 to 14.00 in the afternoon, from 14.00 to 18.00 in the afternoon, from 18.00 to 24.00 in the evening?
I’ve tried with the IF column but it doesn’t work
As long as you have the current hour: HOUR(Now) in a Math column, you should be able to use an If-Then-Else on top of that to return the value Morning/Afternoon/Evening.
1 Like
It should be in reverse, Jam >= 18 then Evening, Jan >= 11 then Afternoon, Jan >= 6 then Morning.
What about midnight to 6?
Yes, that’s right, midnight to 6 o’clock
I mean you haven’t accounted for midnight to 6 in your logic.
Thank you @Jeff_Hager and @ThinhDinh , because of you I achieved the results I hoped for…
I’m a new user on Glide, I still have a lot to learn, I hope you don’t feel bothered by my questions 
3 Likes
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.