Hours in specific time frames

Dell Studio 540
October 16, 2010 at 14:27:16
Specs: Windows Vista, 2.336 GHz / 3292 MB
Below is set out what I have in a timesheet. I want by the shift day to be able to identify the number of employees working between specific hours

Start Finish Hours Title
08:00 20:00 12 Manager
20:00 08:00 12 Trainee
20:00 00:00 4 Operator
20:00 08:00 12 Operator
I want to be able to show in a table no of staff by category (eg Manager)between 8pm to Midnight. Midnight to 8 am and 8am to 8pm

I am trying to get formula which will give me the above results
I should appreciate any assistance
Thanks
Prunchy


See More: Hours in specific time frames

Report •

#1
October 16, 2010 at 14:41:15
First, let's start with a tip about posting data in this forum. This tip can be used for the data tables in your post.

Why not edit your post using the tips below so that we can more easily understand to layout of your data?

To line up data in your post, please use the pre tags found above the Reply box.

1 - Click the pre icon found above the Reply box.
2 - Enter your data between the tags.
3 - Click Preview Follow Up to see if you like the way it looks.
4 - If you need to fix the layout, fix it in the Message box below the Preview box.
5 - Click the "Check To Show Confirmation Page Again" box.
6 - Click either Confirm button to Preview the post again.

Repeat steps 4 – 6 as often as necessary until you like the way the post looks and then click Confirm.


Report •

#2
October 16, 2010 at 15:14:43
Sorry, Will start again, am new to this

EE Start Finish Hours
Title Time Time Wkd
Manager 08:00 20:00 12
Operator 00:00 08:00 8
Sp'visor 20:00 08:00 12
Operator 23:00 07:00 8

I want to identify how many Managers worked in the 24hrs
and how their hours were split into the time frames
8am-8pm, midnight-8am, 8pm to midnight


Report •

#3
October 16, 2010 at 16:50:43
It does not appear that you followed the instructions in my reply. If you had, your data would have looked like this:


   EE         Start      Finish     Hours
  Title       Time        Time       Wkd
Manager      08:00       20:00        12
Operator     00:00       08:00         8
Sp'visor     20:00       08:00        12
Operator     23:00       07:00         8


Report •

Related Solutions

#4
October 16, 2010 at 17:30:51

Afraid I could not follow instructions as totally new to this. Anyway if you can help me it would be appreciated now that you can see what data I am working with.

Report •

#5
October 16, 2010 at 18:57:37
re: "Afraid I could not follow instructions as totally new to this"

New or not shouldn't matter. Do you see the little word pre above the reply box? Click it and see what happens. When it appears in your post, put your data between the > <. The instructions I gave are pretty straight forward.

re: "I want to identify how many Managers worked in the 24hrs"

You didn't give us very much detail to work with.

To answer your question, the answer is 1, which I determined just by looking at your example.

Manager      08:00       20:00        12

There's one occurrence of "Manager" and it appears he worked between 8am-8pm.

If you need a formula to count how many times the word "Manager" appears in your list, this would do it:

=COUNTIF(A1:A4,"Manager")

As far as the hours part goes, I'm not sure what you are asking for. Perhaps a few more examples of Input data and the expected Output would help.

For example, what answer (or answers?) would you expect based on the example you gave us?



Report •

Ask Question