Forum Discussion

Hafnia's avatar
Hafnia
Copper Contributor
May 28, 2020
Solved

Excel graph with time stamp

Dear colleagues,

 

I'm struggling with the graph functions in Excel.

I have a set of data [time,temperature]. My time value starts from 00:28:28 and ends 00:05:00 (so about 37minutes). I have troubles with expressing such set of data as my data turns to 00:00:00 after passing 00:59:59. However, I get a fine graph when I choose the time function h:min:sec. where it misunderstand my data to be 28:28:00 insted of 00:28:28. (Please check attached file)

 

Any idea of how to express my data to start in 00:00:00 and end in about 37:00:00, given by every five minutes on the x-axis? Any help is really appreciated! Thanks in advance!

Resources