# Time formula in Make.com app **URL:** \ **Category:** Apps\ **Tags:** make\ **Created:** [May 24, 2024, 10:19pm UTC](https://forum.seatable.com/t/time-formula-in-make-com-app/4386 "2024-05-24T22:19:16Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![VibusD](https://forum.seatable.com/letter_avatar_proxy/v4/letter/v/90ced4/32.png) [@VibusD](https://forum.seatable.com/u/VibusD)\ **Post date:** [May 24, 2024, 10:19pm UTC](https://forum.seatable.com/t/time-formula-in-make-com-app/4386/1 "2024-05-24T22:19:17Z")
Please let me know how to add the TIME to a Date field accurate to minutes. Here are 8 different ways in both the Make and Rework apps on [Make.com](http://Make.com): ![image](https://forum.seatable.io/uploads/default/original/2X/3/3752d845adf3e9f074220eeebbbb71fe56fffe63.png) Notice the DateTimeText column is simply a text column, and it shows the time codes fine, but the DateTime column does not. ---
**Author:** ![VibusD](https://forum.seatable.com/letter_avatar_proxy/v4/letter/v/90ced4/32.png) [@VibusD](https://forum.seatable.com/u/VibusD)\ **Post date:** [May 25, 2024, 1:04pm UTC](https://forum.seatable.com/t/time-formula-in-make-com-app/4386/2 "2024-05-25T13:04:04Z")
Well, it’s come to this… The state of SeaTable support and forum is subpar to the point of despair and considering returning to “the other table” :-/ I posted [this](https://forum2.seatable.io/t/make-reworked-app-hh-mm-missing-in-date-accurate-to-minutes-field/3267) on March 1st, and 3 months later still no replies. I contacted support throught the [support form](https://seatable.io/en/kontakt) and heard nothing back. I contacted support on [support@seatable.io](mailto:support@seatable.io) and heard nothing back. I made [this post](https://forum2.seatable.io/t/time-formula-in-make-com-app/4386) and while other posts have been answered, this one goes unnoticed. It’s a simple issue, perhaps even a silly question considering it’s such a trivial thing. Nonetheless, the issue persists, and as is evident I’ve attempted to solve this, to no avail. @fsa@rdb @Karlheinz ---
**Author:** ![cdb](https://forum.seatable.com/user_avatar/forum.seatable.com/cdb/32/7_2.png) [@cdb](https://forum.seatable.com/u/cdb)\ **Post date:** [May 28, 2024, 12:57pm UTC](https://forum.seatable.com/t/time-formula-in-make-com-app/4386/3 "2024-05-28T12:57:13Z")
Dear @VibusD I tried to verify your described behaviour and here is what I get: - I used SeaTable Cloud - I created multiple date columns with activated option “accurate to minute” - I used the [make.com](http://make.com) “Rework” app to create new rows. Here is what I get: - now matter what I tried, the DateISO format ignores the hours and minutes. - the other three date formats accept either the “now” from [make.com](http://make.com) or the two different time formats defined in [Models](https://api.seatable.io/reference/models). ![image](https://forum.seatable.io/uploads/default/original/2X/e/eea6e4517902012c193dadf757259f3f9e151afa.png) Therefore, I assume your problem will be solved, if you switch the date format to either “US”, “European” or “German, …”. In the meantime, I will try to clarify why the ISO format does not accept hours and minutes. ---
**Author:** ![cdb](https://forum.seatable.com/user_avatar/forum.seatable.com/cdb/32/7_2.png) [@cdb](https://forum.seatable.com/u/cdb)\ **Post date:** [May 28, 2024, 2:23pm UTC](https://forum.seatable.com/t/time-formula-in-make-com-app/4386/4 "2024-05-28T14:23:22Z")
I can confirm that with version 5.0, the bug ignoring hours and minutes in DateISO will be fixed. Release date for 5.0 is 15th of July 2024. Until then you should change the date format of the date column. ---
**Author:** ![system](https://forum.seatable.com/uploads/default/original/1X/04603423fe81a46c321283663086c475429e8ccb.png) [@system](https://forum.seatable.com/u/system)\ **Post date:** [May 30, 2024, 2:24pm UTC](https://forum.seatable.com/t/time-formula-in-make-com-app/4386/5 "2024-05-30T14:24:19Z")
This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.