Forum Discussion
e175429
Helper IV
Helper IVTransferring time format to BI
Hello all,
This is my table in excel.
| Month | Year | Avg Service Time | Avg Wait Time |
| Jan | 2023 | 0:08:58 | 0:06:40 |
| Feb | 2023 | 0:09:13 | 0:06:24 |
| Mar | 2023 | 0:08:47 | 0:06:54 |
| Apr | 2023 | 0:08:45 | 0:05:57 |
| May | 2023 | 0:08:53 | 0:06:37 |
| Jun | 2023 | 0:09:18 | 0:07:13 |
| Jul | 2023 | 0:10:03 | 0:06:18 |
| Aug | 2023 | 0:09:54 | 0:04:58 |
| Sep | 2023 | 0:09:54 | 0:05:21 |
| Oct | 2023 | 0:08:45 | 0:06:11 |
| Nov | 2023 | 0:09:08 | 0:05:18 |
| Dec | 2023 | 0:09:20 | 0:09:07 |
| Jan | 2024 | 0:09:23 | 0:06:04 |
| Feb | 2024 | 0:09:37 | 0:06:45 |
| Mar | 2024 | 0:09:47 | 0:15:53 |
| Apr | 2024 | 0:09:38 | 0:05:36 |
| May | 2024 | 0:09:47 | 0:05:54 |
| Jun | 2024 | 0:10:46 | 0:06:19 |
| Jul | 2024 | 0:10:33 | 0:05:01 |
| Aug | 2024 | 0:10:24 | 0:05:11 |
| Sep | 2024 | 0:10:12 | 0:04:51 |
| Oct | 2024 | 0:10:02 | 0:05:02 |
| Nov | 2024 | 0:10:44 | 0:05:11 |
| Dec | 2024 | 0:09:44 | 0:06:49 |
When I bring it in to BI, it transforms to this:
It adds dates and changes the time.
The ultimate goal is to show the average wait and service time by year.
How do I get it to show the correct time so I can then calculate on them?
Thank you!
