Time issue

edited 12/09/19 in Smartsheet Basics

Hi All

Please can someone help me with a logistics related time question. I know Time management is limited in smartsheet however I am hoping someone has a clever solution.

We have a column for 'time leaving depot' which is inputted as a time 10:21 for instance.

The next field is 'estimated travel time', in hours:minutes. An example is 14:00.

Where I need the help is there are 'non driving hours' from 23:00 to 04:00 the next morning.

So I need a formula that looks up the departure time, takes the driving hours into account and the non driving time and confirms the estimated time of delivery of in the above example 05:21.

Hope that all makes sense.

I have used the long formula in this post to work out the loading time however have come stuck on what to do next: https://community.smartsheet.com/discussion/using-start-and-end-time-columns-calculate-hours-worked-timesheet-page

If anyone has any ideas I am very keen to hear please. Thank you