Adding Two Time Values 1

[MontgomeryPete]

This should be simple, but I can't seem to add two time values calculated using the DateDiff function.

We want to calculate elpased driver time to reduce overtime.

FirstRun:Format(DateDiff ("n",DriverStartTime,LunchOut)/1440,"ShortTime")

SecondRun:Format(DateDiff("n",DriverEndTime,LunchIn)/1440,"ShortTime")

TimeWorked[FirstRun]+[SecondRun])

If [FirstRun] =4:30 and [SecondRun] = 4:30 the value for [TimeWorked] is 4:304:30.

How can you add time values? The DateAdd function won't work for this. I have searched many threads, but can't find one that describes the necessary conversion.

Thanks for your help.

 

[SkipVought]

Hi

Datediff already does the conversion, so loose the division by 1440
[tt]
FirstRunateDiff ("n",DriverStartTime,LunchOut)

SecondRunateDiff("n",LunchIn, DriverEndTime)

TimeWorked[FirstRun]+[SecondRun])
[/tt]
where [FirstRun], [SecondRun] & [TimeWorked] are in units of MINUTES as defined by DateDiff INTERVAL "n"

Skip,

_{To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white]}

 

[MontgomeryPete]

Skip,
Thanks for the quick help. I ahd forgotten that the conversion is done in DateDiff.

Pete