Transferring time format to BI

[e175429]

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!

[Irwan · Accepted solution]

hello @e175429 

perhaps changing the format from datetime into time will fix the problem.

Hope this will help.

Thank you.