Formula for minutes per month

[Former Member]

Post Author: olesco

CA Forum: Formula

How do I get the total number of minutes per month?

RcvdDt Month CalendarDays #OfDays(excl Hol, Sat,&Sun) MinPerDay TotalMin/Mo

8/13/2007 8:40:25AM 8/07 31 23 1440 33120

9/6/2007 1:27:00PM 9/07 30 19 1440 27360

10/9/2007 1:27:00PM 10/07 31 22 1440 31680

Any help is greatly appreciated. Thank you.

[Former Member]

Post Author: Lugh

CA Forum: Formula

Try Ken Hamady's solution: http://kenhamady.com/form01.shtmlYou'll need to enter in all of your holidays yourself in the array. But, after that, just run the formula with the first and last date of each month.

[Former Member]

Post Author: olesco

CA Forum: Formula

I forgot to mention I have XI r2

[Former Member]

Post Author: olesco

CA Forum: Formula

I'm sorry my question is not clear. What basically I'm trying to say is, how do I know the number of days in a certain month and then multiply that number of months to 1440/day. Thank you.

[Former Member]

Post Author: V361

CA Forum: Formula

This will give you the number of days in a month (just change {Orders.Order Date} to your date field. day(cdlastdayofmonth ({Orders.Order Date}))

You could then just multiply by 1440 to get total available seconds in the month. day(cdlastdayofmonth ({Orders.Order Date})) * 1440

If you are looking for available seconds Use your #0fDays(excl Hol, Sat, & Sun) formula and multiply it by 1440. Hope this helps.

[Former Member]

Post Author: Lugh

CA Forum: Formula

Er, don't you already have it there? Minutes per day (1440), times the number of days in the month (in this case, you're using #OfDays). What else are you looking for?