Timeformat

[n1ef5ng1]

Hi Guys,

I have two field call Arrival_Time and Departure_Time

The format for this two time is

10/01/2012 16:48:00

and

01/02/2012  20:00:00

I need to find the difference of this two time(Arrival and Departure) via Days

Any ideas on how I can do it, thank you

[sushil353]

Hi,

Check out interval function:

interval( A-B, 'D hh:mm' ) where A=97-08-06 09:00:00 and B=96-08-06 00:00:00 returns:

String	365 09:00
Number	365.375

HTH

Sushil

[kumarnatarajan]

Hi,

Try the below syntex.

EX : =Interval(Arrival_Time-Departure_Time,'DD')

[#4 · Accepted solution]

Extract date from both the dates using Function DATE and then convert it into number format and then operate the subtraction

Num(Date (Arrival_Time,'DD/MM/YYYY')) - Num(Date (Departure_Time,'DD/MM/YYYY'))

another way is

using the same technique, convert into date and then use DATEDIFF function.