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.
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.
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.
Add a comment