Interval value into number

[manojkulkarni]

Hi Friends,

I am using interval function to calculate difference of 2 dates & getting difference values in minutes. I need to use this value to calculate % of total minutes in month. eg: my derived values in 768 minutes and total minutes available is 41760. % is 1.8%. but i am getting a different value all together which is .0013%.

When I convert the above value 768 to number using num() function, it returns me .0056.. something.

Why can't we use 768 value directly ?

[Gysbert_Wassenaar · Accepted solution]

The unit of times and dates is days. The interval function still returns a value with a unit of days. If you format the result of the difference between two dates in minutes you only change the display format. The real value is still in days. There are 1440 minutes in a day so if you want to use 768 directly then you have to multiply it by 1440.

[Kushal_Chawda]

Try this

time(frac(round(Date1,(1/24*60))) - frac(round(Date2,(1/24*60))),'mm')

[manojkulkarni]

thanks Gysbert Wassenaar,

it worked.