I don't think Chip's formula will work when the ticket can be created at any time.

Can you clarify what you actually want to calculate, do you want to calculate the time and date that you must finish the job or do you want to calculate how many working hours have passed since the ticket was created (and thereby calculate how many hours you have left)?

The latter is easier to do.

What time is lunch?