Counting a travel day as half if travel starts before specific time

Hi!

I'm making a spreadsheet to calculate per diems for my staff.
Swedish tax laws state that a travel day counts as half if the trip starts after 12.00 (noon), and/or ends before 19.00 (7pm)

I'm looking for a formula where I can use two cells with the "date and time" format (one cell for start date/time and one cell for end date/time) and automatically calculate half days and whole days.

If this is possible in the way I described, or any other way, I'm very grateful for tips!

All the best,

Åke Andersson
Ankarhult Group

Great, that's what I was looking for

All the best,

Åke