Difference Between Time Data Type

Himanshu_Nigam

I am having Two Variable Time Datatype
a) StartTime
b) EndTime

I need Diffrence Between EndTime - StatTime how to do ???????

Marije_Brummel

Do you want the result in a Time variable or a Decimal

Decimal := Time1 - Time2
Time := Time1 - (Time2  - 000000T)

vaprog

When you subtract a Time from a Time you get a Duration.
You can add and subtract a Duration to/from a Time.
The system automatically converts a Duration to an Integer if so needed.

Duration := Time - Time;

At first, I wondered about Marc's unusual construct of subtracting 000000T from Time2, which appears to do nothing. But in fact, it "converts" Time2 to a Duration, which then can be subtracted from Time1. Also 0T does not work. It denotes "no time" whereas 000000T denotes midnight.

mdPartnerNL

Thanks. Not sure I ever need it but learning all the time

Marije_Brummel

vaprog wrote:

... Mark's unusual construct ....

Yes, simetimes I am unusual...

DenSter

Mark Brummel wrote:

Yes, sometimes I am unusual...

sometimes....