Report

How to get the ratio of start and enddate. [Closed]

Hello,

can anyone help me to get the ratio of startdate, enddate.

startdate = 2016-02-14 20:10:10
enddate = 2016-02-14 23:59:59
c= 44:10:09 (Total time of 2016-02-14)

r = (ratio(23:59:59) - ratio(20:10:10)) /44:10:09;
NOte: convert 20:10:10, 23:59:59 by minutes before taking the ratio. 44:10:09 also convert it by minutes while taking r value

Thanks in advance, AAA

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!