12,894,700 members (57,923 online)
Rate this:
See more:
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.

ex:
```Start Time = 01:00:00(Day1), End Time = 07:00:00(Day2)
The result is 06:00:00 ```
but this is incorrect

Posted 25-Sep-12 3:09am

Rate this:

## Solution 1

Why don't you consider the date or days elapsed. You can use the formula

(FinalTime - InitialTime) + (DayDiff * 24)

e.g. 01:00:00 (day1) and 07:00:00 (day2), then
6 + 24 = 30 hrs.

Top Experts
Last 24hrsThis month
 OriginalGriff 190 Jochen Arndt 155 Richard Deeming 130 Richard MacCutchan 118 ppolymorphe 100
 OriginalGriff 5,172 CHill60 3,528 Jochen Arndt 2,958 Karthik Bangalore 2,456 ppolymorphe 2,265

Web02 | 2.8.170424.1 | Last Updated 25 Sep 2012