10,500,000 members (54,670 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
 Richard MacCutchan 300 OriginalGriff 223 Dave Kreskowiak 180 Karthik Bangalore 160 RyanDev 115
 Richard MacCutchan 300 OriginalGriff 233 Dave Kreskowiak 205 Karthik Bangalore 180 RyanDev 115