Forum Discussion
Date / Time manipulation with PowerQuery
I have a few columns in my Excel and try to do some change with PowerQuery. Very new to it and thanks to Sergei for the first steps, I have the following columns Start Time (UTC) 8/8/2022 1...
PaddyB The easiest would be to start by setting the data type in PQ, for both start time and duration to a decimal number. Then you can simply add 2 hours (=2/24 of one day) to the start time to get CEST and then add the duration to get the end time CEST.
See attached.
how simple 🙂
was testing and trying for a long time... will give it a try as soon i will be at home this eve.
thaks so much for it
was testing and trying for a long time... will give it a try as soon i will be at home this eve.
thaks so much for it