Calculating due dates

ssblue
ssblue used Ask the Experts™
on
Excel - I need to calculate the next due date based off the field Intervals which is in hours.

Please see attachment
DueDates.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Roy CoxGroup Finance Manager

Commented:
Are there any rules, e.g. does 12 hours roll over to the next day, is 50 hours 4 or 5 days?
Roy CoxGroup Finance Manager

Commented:
Have a look at this, I've used the CONVERT Function

=B2+CONVERT(A2,"hr","d")
DueDates.xlsx
ssblueCoordinator

Author

Commented:
That works!  Is there a way I can use it with   NOW()   for the current date?

I am only looking at the date and not really looking at the time of day.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Group Finance Manager
Commented:
I just put some dates in. It will work if you use TODAY or NOW. See attached
DueDates.xlsx
ssblueCoordinator

Author

Commented:
Thanks for the help! :)
Roy CoxGroup Finance Manager

Commented:
Pleased to help

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial