Avatar of Steve B
Steve BFlag for Australia asked on

Excel formula required that calculates the total time from start to finish for each date period

I have a spreadsheet that is used to calculate different jobs that my staff do as chauffeurs.

What I would like is a formula that looks at the date column, then the start column for the time work started then finds the row that contains the last input of that date and the finish time and calculates the number of hours on the job.

The thing is that on the spreadsheet there are multiple dates, so it would need to search and find the start and finish time of each date on the spreadsheet and calculate the number of hours on the job for each date, showing the total amount of time on the job for that particular spreadsheet (or the work shown on the spreadsheet).  

The total amount of hours should be shown in the format of [h}:mm and be displayed in cell AB6.

One spreadsheet would normal have about 150 plus jobs on it, over a 15 day period.  So we would use about 150 rows starting from Row A13.

Also, please do not convert or save the spreadsheet in xlsx.  Most of my workers still use the xls format.


For privacy reasons I have remove the prices and Client Names from the spreadsheet.
COPY-Chauffeur-SpreadSheet-Invoi.xls
Microsoft ExcelVisual Basic ClassicVB Script

Avatar of undefined
Last Comment
Steve B

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
byundt

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Steve B

Absolutely great.  Works exactly the way I wanted it to.  You guys on Expert Exchange are sheer brilliant.  Best website and team of professionals I have ever come across.  Quick to respond and 9 out 10 times on the mark with success.

Thanks.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy