Formula for hours in Current Month.

[sice]

Any idea on a formula that tells me how many hours are in the current month? Thank you!

 

[Jonmo1]

Basically number of days in the month*24

Number of days in the month =
=DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,0))

Then multiply by 24
=DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,0))*24


Hope that helps.

 

[jmthompson]

***jonmo1 beat me to it

If it is the current month

=(DAY(EOMONTH(NOW(),0)))*24

 

[Jonmo1]

***jonmo1 beat me to it

If it is the current month

=(DAY(EOMONTH(NOW(),0)))*24

No I didn't....I had typos in there...corrected now.

should be
=DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,0))*24


Should be noted that this:
=(DAY(EOMONTH(NOW(),0)))*24
Requires the analysis toolpack from Tools - Addins.

 

[jmthompson]

huh, had no idea I had the Analysis toolpack