telling time

[fwday]

I am making a schedule. I have a worksheet with 64 cells going accross.
Each Cell is 15min. I want to be able to fill them in with an opject,
like "-" for the time they work and a "+" for the time they are on
lunch. Then at the end of that row I want it to tell me what time they
are working at a glance.

I am in need of some serious help.
(e-mail address removed)

 

[J.E. McGimpsey]

One way:

BM1: =TIME(0,COUNTIF(A1:BL1,"-")*15,0)

formatted as h:mm

 

[fwday]

How is that going to give me a start time and an end time?

 

[Tom Ogilvy]

you said:

Then at the end of that row I want it to tell me what time they
are working at a glance.

Which JE interpreted to mean the total time worked.

You just said 64 cells, so where is the first cell and the the last cell?
What to you want to see on the end of the rows Start, stop before lunch,
start after lunch, stop or just the initial start and stop.

What columns do you want them in. In your next posting, you are talking
about results being on a separate sheet and maybe entering + and -.