I'm making a travel time sheet for technicians to fill in travel, the input should be broken down based on driving time period.
Between 7AM and 5 PM should be considered as standard time, before 7AM is morning, after 5 PM is Evening
This is easy, the hard part for me is to break it up when there is an overlap when driving, say for example he drives from 6AM untill 8AM, so partly morning and partly standard time, same when driving from 4PM till 6PM partly standard and evening.
Who can help me with formula I tried IF statement but get stuck...
Between 7AM and 5 PM should be considered as standard time, before 7AM is morning, after 5 PM is Evening
This is easy, the hard part for me is to break it up when there is an overlap when driving, say for example he drives from 6AM untill 8AM, so partly morning and partly standard time, same when driving from 4PM till 6PM partly standard and evening.
Who can help me with formula I tried IF statement but get stuck...