Mathematics with date.

[#1]

Hi Experts,

In my script, I have created a field

Interval(num(Date1)-num(Date2),'ss') as Difference

which  gives me the difference between the two dates in seconds.

Using the same field I am writing an Expression:

=Sum(Difference)/3600   

which converts the sum of difference in dates to hrs.

But what I am getting is Num(Sum(Difference))/3600 which is not required.

How to solve this issue.

hic  please see if you can help me on this.

Regards,

Anjali Gupta

[PrashantSangle]

Hi,

try interval(date1-date2,'D hh:mm:ss')

Regards

[thomaslg_wq]

I don't understand what you really need but maybe :

as max dreamer says:

=Interval(date-date,'hh.mm.ss')

or

Round the hours and change the minutes with 60/100

=(ceil($(differencesecond)/3600))-1+(0.6-(ceil($(differencesecond)/3600)-($(differencesecond)/3600))*0.6)

[#4]

Thanks Jonathan for the help. I worked the way I wanted.