time subtracting

[Former Member]

Hi All,

I have 2 date time fields intime and outtime.

Now I need to subtract in time from out time to get total working time.The result should be like this.

4.10

So I am doing like this.But getting the error like A number or currency,date fieled required.

Please help

ToText({Command.out_time}, "hh:mm") -ToText({Command.in_time}, "hh:mm")

[abhilash_kumar · Accepted solution]

Hi Kalyan,

Try this:

numbervar TotalSeconds := DateDiff("s",{Command.out_time}, {Command.in_time})

numbervar Hours := Truncate(TotalSeconds / 3600);

numbervar Minutes := truncate((TotalSeconds - (Hours * 3600))/60);

numbervar Seconds := Truncate(Totalseconds - (Hours * 3600) - (Minutes * 60));

Hours & ":" & Minutes

-Abhilash

[Former Member · Accepted solution]

Hi Abhilash,

I am getting result but with -ve sign like -4:10.I need to deduct in time from out time.

If I reverse intime and outtime in 1st line of code I am getting the result.

Please suggest

[abhilash_kumar · Accepted solution]

Yes, reverse the fields used in the DateDiff function.

-Abhilash

[Former Member · Accepted solution]

Many Thanks Abhilash