Getting calender days from hours required.

[lewislusby]

I know the amount of hours needed for a job and the start date, how can I get the end CALENDER date. Help!

 

[bebo021999]

I know the amount of hours needed for a job and the start date, how can I get the end CALENDER date. Help!

Try this;
Ending date = starting date + hour/24

 

[Biz]

Try Formula below

A2 Start date and B2 is hours required.
=A2+(B2/24)
Biz

 

[lewislusby]

But I dont want to include weekends

 

[Biz]

Try

=WORKDAY(A2,B2/24)

Biz

 

[lewislusby]

Biz, your the biz!

Cheers

 

[Biz]

No problems M8