Answered

TIme Format within HTML Table

(0) Share

Report

Posted on by booyaa33

I am currently building a flow that filters and sends emails out to workers with work they have completed over the last month. However, whenever I use the Time formats in Excel, it is reformatted on the output email as this:

I was also having difficulties with the date function but was able to get it sorted but unable to find any useful information for doing the same with time formats.

What should I be putting within the value section of the HTML Table to reformat these numbers into HH:MM? GMT by the way!

Thanks in advance!

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

eliotcole 4,390 Moderator on at

Like (0)

Report
Copy link

Link copied!

I'm not saying this sarcastically, @booyaa33, but if you search for "convert excel dates" on this forum you might find what you're looking for.

I mean, don't just leave it there, try more than that search, but this must have come up numerous times.

EDIT - Yeah, literally the first result in that search provides a possible answer here, and there are more. That first one indicates that you can decide how the dates are formatted when you're picking data from excel from a drop down menu, and there's probably a few other solutions there, too.

Was this reply helpful? Yes No
booyaa33 8 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the suggestions! I checked out that result you mentioned but seems to be mainly related to dates rather than times? I'm happy that I have the dates sorted but times are the issue, unfortunately.

Was this reply helpful? Yes No
eliotcole 4,390 Moderator on at

Like (0)

Report
Copy link

Link copied!

Like I said, @booyaa33, "don't just leave it there" ... you need to delve further and do a little work. 😉

Also the ISO8601 format which is referenced in that first result actually *always* involves times by default. The format is yyyy-MM-ddThh:mm:ss.0000000Z (i may have the milisecond format wrong 😅) and that quite clearly can contain the time, in fact it even allows for time zone information with an extended value set.

Anyway ... yeah ... 8601 includes the time.

Was this reply helpful? Yes No
booyaa33 8 on at

Like (1)

Report
Copy link

Link copied!

Apologies @eliotcole, I am very new to this so didn't mean to come across as lazy! Currently 5 hours deep into finding a resolution to this so the forum was the next step before losing my mind!

Was this reply helpful? Yes No
eliotcole 4,390 Moderator on at

Like (0)

Report
Copy link

Link copied!

It's all good, mate ... what I don't know you could fill encyclopaedias with!

Was this reply helpful? Yes No