In a line graph I plot certain values against time programatically(Macro)for a survey.
The number of hours in a survey are not same always. In order to divide the x-axis (time) in equal intervals,
Eg: The time is starts from 00:00:00 to 19:00:00.
TotalTime = FinalTime - InitialTime
TotalTime = 19:00:00 - 00:00:00
TotalTime = 19:00:00
But in a new data set I got, the survey runs for 2 / 3 days continuously.
So now to check the total number of hours, when the final and initial values are subtracted, the resulting value is only few hours.
Start Time = 01:00:00(Day1), End Time = 07:00:00(Day2)
The result is 06:00:00
but this is incorrect
Need some suggestions please