Looking up dates and splitting a travel cost evenly

[Zippoah]

Hi,

I want a formula that will look up dates and split a travel cost evenly for contractors.

For example:

If they work on two jobs on one day, I want to split the daily travel costs evenly.

1/1/2018 Job A 8 hours
2/1/2018 Job A 4 hours
2/1/2018 Job B 4 hours
3/2/2018 Job C 8 hours
4/2/2018 Job C 2 hours
4/2/2018 Job D 6 hours

Daily travel: $20.50

So what formula do I use to lookup the dates and split the travel so it will give me the following:

1/1/2018 Job A 8 hours $20.50
2/1/2018 Job A 4 hours $10.25
2/1/2018 Job B 4 hours $20.00
3/2/2018 Job C 8 hours $20.00
4/2/2018 Job C 2 hours $5.125
4/2/2018 Job D 6 hours $15.375

Thank-you for any help!

 

[Zippoah]

I tried a VLOOKUP function and listed the split amount for each hour, but I want it to be able to check if there are duplicates for the date and then split. Otherwise, I want to give it the full amount for the daily travel costs:

For example:
1/1/2018 Job A 8 hours $20.50
2/1/2018 Job A 4 hours $10.25
2/1/2018 Job B 4 hours $20.00
3/2/2018 Job C 8 hours $20.00
4/2/2018 Job C 2 hours $5.125
4/2/2018 Job D 6 hours $15.375
5/2/2018 Job D 6 hours $20.50 (as there are no other jobs for that day)

Thanks again!