How to make 00:30 ( time ) appear as in table ?

[#1]

Hi All

My excel raw data file have 00:30 , which is time . I need to plot the value display on chart or table.

May i know how to convert the data so that it can display on table or chart ?

Enclosed my QVW file for your ref.

Paul

[#2 · Accepted solution]

Hi Paul,

PFA.

Hope it helps!

[#3]

Thank you very much it work.