MILITARY TIME FORMAT FORMULA

Hi good day im just new here just wanna seek some help regarding ok my formula though it was already working but the result is 12hour format and not 24hour format heres my formula

=IF([Case Type]@row = "Internal Service Issue", "ISI", IF([Case Type]@row = "External Service Issue", "ESI", IF([Case Type]@row = "Agency Debit Memo", "ADM", IF([Case Type]@row = "General and Admin", "GEN", "")))) + IF(MONTH(Created@row ) < 10, "0" + MONTH(Created@row ), MONTH(Created@row )) + IF(DAY(Created@row ) < 10, "0" + DAY(Created@row ), DAY(Created@row )) + RIGHT(YEAR(Created@row ), 2) + SUBSTITUTE(MID(Created@row , 10, 5), ":", "") + "-" + [Auto ID]@row

it shows like that instead of a 24 hour format like for example ISI0804251332 instead

Find more posts tagged with

Accepted answers

Paul Newcome

Try replacing the part that outputs the time with this:

SUBSTITUTE(TIME(RIGHT(Created@row , 8), 1), ":", "")

Paul Newcome

Happy to help. 👍️

All comments

Paul Newcome

Try replacing the part that outputs the time with this:

SUBSTITUTE(TIME(RIGHT(Created@row , 8), 1), ":", "")

shaunnelei

wow your such a great paul it works on my end thank you so much appreciated your help

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.