# Takes the hours and minutes from the date
**URL:** https://community.glideapps.com/t/takes-the-hours-and-minutes-from-the-date/77300
**Category:** Ask for Help
**Created:** [October 24, 2024, 2:13pm UTC](https://community.glideapps.com/t/takes-the-hours-and-minutes-from-the-date/77300 "2024-10-24T14:13:39Z")
**Posts on this page:** 14
**Page:** 1
### Author:  [@agung\_taufik1](https://community.glideapps.com/u/agung_taufik1)
#### Post date: [October 24, 2024, 2:13pm UTC](https://community.glideapps.com/t/takes-the-hours-and-minutes-from-the-date/77300/1 "2024-10-24T14:13:40Z")
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
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 24, 2024, 2:35pm UTC](https://community.glideapps.com/t/takes-the-hours-and-minutes-from-the-date/77300/2 "2024-10-24T14:35:10Z")
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.
```auto
HOUR(Date) +
MINUTE(Date)/100
```
---
### Author:  [@agung\_taufik1](https://community.glideapps.com/u/agung_taufik1)
#### Post date: [October 24, 2024, 2:56pm UTC](https://community.glideapps.com/t/takes-the-hours-and-minutes-from-the-date/77300/3 "2024-10-24T14:56:11Z")
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
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 24, 2024, 5:32pm UTC](https://community.glideapps.com/t/takes-the-hours-and-minutes-from-the-date/77300/4 "2024-10-24T17:32:13Z")
Do you mean that you want the Month name instead of a number?
---
### Author:  [@agung\_taufik1](https://community.glideapps.com/u/agung_taufik1)
#### Post date: [October 24, 2024, 5:35pm UTC](https://community.glideapps.com/t/takes-the-hours-and-minutes-from-the-date/77300/5 "2024-10-24T17:35:29Z")
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
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 24, 2024, 6:42pm UTC](https://community.glideapps.com/t/takes-the-hours-and-minutes-from-the-date/77300/6 "2024-10-24T18:42:26Z")
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.
---
### Author:  [@agung\_taufik1](https://community.glideapps.com/u/agung_taufik1)
#### Post date: [October 24, 2024, 11:46pm UTC](https://community.glideapps.com/t/takes-the-hours-and-minutes-from-the-date/77300/7 "2024-10-24T23:46:08Z")
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
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [October 25, 2024, 12:05am UTC](https://community.glideapps.com/t/takes-the-hours-and-minutes-from-the-date/77300/8 "2024-10-25T00:05:04Z")
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.
---
### Author:  [@agung\_taufik1](https://community.glideapps.com/u/agung_taufik1)
#### Post date: [October 25, 2024, 12:41am UTC](https://community.glideapps.com/t/takes-the-hours-and-minutes-from-the-date/77300/9 "2024-10-25T00:41:45Z")
> [@ThinhDinh](#):
>
> `HOUR(Now)` in a Math column
yes. I have
is my if column correct?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [October 25, 2024, 12:42am UTC](https://community.glideapps.com/t/takes-the-hours-and-minutes-from-the-date/77300/10 "2024-10-25T00:42:37Z")
It should be in reverse, Jam \>= 18 then Evening, Jan \>= 11 then Afternoon, Jan \>= 6 then Morning.
What about midnight to 6?
---
### Author:  [@agung\_taufik1](https://community.glideapps.com/u/agung_taufik1)
#### Post date: [October 25, 2024, 12:49am UTC](https://community.glideapps.com/t/takes-the-hours-and-minutes-from-the-date/77300/11 "2024-10-25T00:49:00Z")
> [@ThinhDinh](#):
>
> What about midnight to 6?
Yes, that’s right, midnight to 6 o’clock
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [October 25, 2024, 12:57am UTC](https://community.glideapps.com/t/takes-the-hours-and-minutes-from-the-date/77300/12 "2024-10-25T00:57:42Z")
I mean you haven’t accounted for midnight to 6 in your logic.
---
### Author:  [@agung\_taufik1](https://community.glideapps.com/u/agung_taufik1)
#### Post date: [October 25, 2024, 1:42am UTC](https://community.glideapps.com/t/takes-the-hours-and-minutes-from-the-date/77300/13 "2024-10-25T01:42:41Z")
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 😀
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [November 1, 2024, 1:42am UTC](https://community.glideapps.com/t/takes-the-hours-and-minutes-from-the-date/77300/14 "2024-11-01T01:42:52Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.