Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Bit of a convoluted solution here.
Spoiler
Firstly a Formula tool was used to write a IF loop to add a zero to the start of some times that only had a length of 3, eg 815 -> 0815.
Next two date time tools were utilised to insert commas into the times to break up the hours and minutes.
A select tool was used to convert the Begin/End Time columns from time into strings so the next formula could be completed. The Formula was just using the DateTimeDiff to calculate the time elapsed in minutes.
Another select tool was used to rename and remove the appropriate columns and switch the type of the columns back into a time format.
Two datetime tools were used to remove the seconds from the Time columns before a select tool was used again to rename and reshuffle the appropriate columns.
Finally, two text to columns tools were used to split the time and the am/pm into two different columns before a final select tool was used to rename, remove and reshuffle the appropriate columns to arrive at the same result as the given output.
Next two date time tools were utilised to insert commas into the times to break up the hours and minutes.
A select tool was used to convert the Begin/End Time columns from time into strings so the next formula could be completed. The Formula was just using the DateTimeDiff to calculate the time elapsed in minutes.
Another select tool was used to rename and remove the appropriate columns and switch the type of the columns back into a time format.
Two datetime tools were used to remove the seconds from the Time columns before a select tool was used again to rename and reshuffle the appropriate columns.
Finally, two text to columns tools were used to split the time and the am/pm into two different columns before a final select tool was used to rename, remove and reshuffle the appropriate columns to arrive at the same result as the given output.
