Figuring Lapse Time

(G1) 24 Hours / Day

Hrs Hrs Left START END
30 (C3) 30 (Q3) 12/4/07 10:00 AM 12/5/07 4:00 PM
3 12/5/07 4:00 PM 12/5/07 7:00 PM
30 30 12/5/07 7:00 PM 12/7/07 1:00 AM
45 45 12/7/07 1:00 AM 12/9/07 10:00 PM
(Need formula)
This is my spreadsheet
I have a formula to calculate days based on 6 days a week
=Q3+C3/$G$1+INT(C3/144+(WEEKDAY(Q3,3)+MOD(Q3,1))/6)

I need one that calculates workdays only.
Sorry I have asked so many times but nothing is working and I may not have explained myself.

Hello Gail,

Please stick to a single thread so that everybody knows the full story.

I believe I posted 2 working solutions in your other thread here

If you can't get those to work please reply to that thread explaining why, thanks. I'm locking this thread