What is a formula that can extract just the time in HH:MM (24hr time) from a "modified date" column.

I need just the time from a modified date column I titled "Ticket closed (24h Format)" and I'm having trouble extracting it into the column titled "Ticket closed time." Here's a screenshot. I've tried using the following formulas as well:

Formulas:
=LEFT([Ticket closed (24h Format)]@row - DATEONLY([Ticket closed (24h Format)]@row), 5)

=HOUR([Ticket closed (24h Format)]@row) + ":" + IF(LEN(MINUTE([Ticket closed (24h Format)]@row)) = 1, "0" + MINUTE([Ticket closed (24h Format)]@row), MINUTE([Ticket closed (24h Format)]@row))

=HOUR([Ticket closed (24h Format)]@row) + ":" + IF(LEN(MINUTE([Ticket closed (24h Format)]@row)) = 1, "0" + "" + MINUTE([Ticket closed (24h Format)]@row), MINUTE([Ticket closed (24h Format)]@row))

Find more posts tagged with

Accepted answers

All comments

dojones

Try this:

=TIME(RIGHT([Ticket Closed]@row, 8), 1)

Arjuna Quezada

Thank you so much, That worked perfectly

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.