Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I've got a huge dataset and one of the columns has Time in it. Currently the time is in the 12 hour Format - '08:00:00 AM', '04:25:00 PM' etc. I want to convert it into 24 Hour Format so that i can divide the time into distinct groups based on office rosters.
Can you please help me out. I have explored various options like Data Type etc but cant seem to crack it.
Solved! Go to Solution.
@danishaomar , Make sure data type is time. Under Column tools format choose the required format
@danishaomar , Make sure data type is time. Under Column tools format choose the required format
User | Count |
---|---|
57 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |