Travel time problem

[Guest]

Hi, I need to create sheet which calculates time and travel time. Each
employee has number of trips and 15 minutes travel time between the clients
less the first one. the spreadsheet calculating the time is columns stating
the number of hours spent with the client for each day. Bellow is example of
it.
Mon. Tues. Each day has a separate column to Sunday.
1:00 2:00
2:00 1:00
5:00 2:00
4:00
As you can see from the example, each day is different in the number of
clients to travel to. First client does not count. It is only from the second
to the last at 15 minutes each. How can I extract the relevant information in
hh:mm form from the columns I have? Could anybody come with help please?
Thank you - Paul

 

[Bob Phillips]

=(COUNTA(A:A)-2)*TIME(),15,0)

and format as time

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[David Biddulph]

I assume that Bob intended:
=(COUNTA(A:A)-2)*TIME(0,15,0) ?