I do 2 contract jobs per day. Have to subtract 1 hrs total each day from commute.
Most of thr time itcomes out of my first job commute and my second is zero. Have formulas for them.
Problem is when I drive 25 for the first job and it subtracts it out but my next job takes 50 minutes.
I need a conditional formula that wi figure how much of the 2nd amount to subtract out just 35 minutes from the 2nd job.
Part of my issue is that I can’t see to just use numbers because excel and Google sheets have a crazy way they do time duration.
First job goes on one row and the second goes on the next row.