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

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

and format as time

--
HTH

Bob Phillips

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

"Paul" wrote in message
...
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

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

"Bob Phillips" wrote in message
...
=(COUNTA(A:A)-2)*TIME(),15,0)

and format as time

--
HTH

Bob Phillips

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

"Paul" wrote in message
...
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