02-11-2020 07:14 AM - last edited 02-17-2020 07:43 AM
Title: Convert Excel serial time
Description: converts excel time into readable date time format that you can then write to a destination, or for any other process.
Detailed Instructions: This is a simple flow and it should simply plug and play.
You can change the trigger for your needs.
The only step that requires attention is the step where you specify your time column to split.
Be sure to process your excel rows within the apply to each to be able to access the date time for each row.
The comments within the flow actions should explain the entire flow.
Questions: If you need help integrating this, post a question here.
Anything else we should know: There is a solution somewhere in the community that I have seen before.
This flow however will convert the entire date time and includes hours, minutes, and seconds.
If you normally work with excel files that are exported from other systems, most likely you run across the excel serial time format and this flow should be very useful for that.
Solved! Go to Solution.