Time columns from Excel to Smartsheet via Data Shuttle

I'm trying to Data Shuttle an Excel doc from another system into Smartsheet. All is fine, except for the Start Time and End Time columns.

They look like this in Excel:

But when I pull them into Smartsheet via Data Shuttle, the columns show only the date part of those columns:

I'm really only interested in the time component of these two columns.

Any guidance anyone may have is greatly appreciated.

Find more posts tagged with

Sheets

Data Shuttle

dates

Accepted answers

All comments

Jovana.Perkovic

Hi @Brett.Longdin ,

I would separate date and time columns in excel and then MAP it with Smartsheet. So you would have Start Date, Start Time, End Date, End Time. Let me know do you need help with excel formula to automatically separate date and time.

Brett.Longdin

Thanks, Jovana. Trying to move the data to Smartsheet without any additional Excel work. I can copy/paste the cells from Excel to Smartsheet and the Time displays fine.

Sounds like adding a couple additional Excel columns might have to be the way to go.

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.