Need some help on a function to show hourly breakdown instead of daily/weekly

I've got a formula in a spreadsheet that works very well in adjusting a schedule from days, weeks or months. However, I need it to be able to show days broken into work hours as well.The formula is below:

=IF(frequency="Weeks",IF(AND(WEEKDAY(startdate)>1,WEEKDAY(startdate)<7),(startdate)-WEEKDAY(startdate)+2,IF(WEEKDAY(startdate)=7,startdate+2,startdate+1)),IF(frequency="Months",DATE(YEAR(startdate),MONTH(startdate),1),startdate))

This formula is pretty far out of my comfort zone as to writing. I really need some help on this. Any help would be greatly appreciated!

Thanks,

Daniel Dawson

HI Daniel,

Suggest you to change the thread title to reflect the query you are asking... see forum rules:_

http://www.excelforum.com/forum-rule...rum-rules.html

Regards,
DILIPandey

<click on below 'star' if this helps>