WORKDAY with Formulas, TIME Format & Work Hours

[kpeacock]

Can someone help with a workday question.
Analysis ToolPak is loaded & checked.

I have tried variations of the workday function without success.

My questions are:
Can you have a formula where Number of Workdays goes, if so how?
Can the format be TIME?
How do I address work hours?

Row 1
Col A = Start Date/Time = 9/5/08 4:00 PM Fri
Col B = End Date/Time = WORKDAY FORMULA GOES HERE
Col C = Duration = 1 hr 30 min

My cell format for Col A and B is mm/dd/yy h:mm AM/PM ddd
My cell format for Col C is h:mm.

Col B cannot be a Weekend or Holiday, and work hours 8 to 5
Expected Result is: 9/8/2008 8:30 AM Mon

This is an example of what I have that is not working.
(the holidays is working when just a NUMBER is entered where A1+C1 is in the formula)

IN ROW:1, COl:B =WORKDAY(A1,A1+C1,holidays)

 

[dewilaz]

I found solution, case closed.

How to Calculate Net Work Hours Between Two Dates - Excel Tactics

Hi guys,

any ideas?

I have start and end times of the task (DATE + TIME).
Work hours: 08:00 - 17:00
Goal is to calculate how long did it take to complete task (excluding weekends(holidays) and non working hours).

Could someone please help with calculation?