The reason that you need to seconds in the DATEADD formula is because the 14 hours is in a duration field and the actual value is stored as 14 times 3600, which is what 14 hours is in seconds. Sorry if this isn’t exactly what you are looking for. Converting a 12-hour time to 24-hour time is straight forward, though confusing. But you can convert the visible value to 24hr format using the Time.ToText function in the next column. time(Time, 0, 0) The display of am/pm is based on your local machine settings. For our program, you would simply add the minutes to the converted hour (no need to use a colon except for the midnight hour). Add 12 to any hours from 1 PM to 11 PM, and change 12 AM to 0. Ive just included a full query above for you to look at. Converting 12 hour time to 24 hour time is relatively simple. So essentially the below in a new custom column. ![]() Hopefully this gives you some clarity and ways you might be able to accomplish what you want. So time(24,0,0) works, time(24,1,0) will not. ![]() Interesting, sorry, I had the wrong field typed in my answer, any of those formulas should have been used the field )įinally the Meeting field does CONCATENATE(DATETIME_FORMAT(Date,'M/D/YYYY')," at ",TIME)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |