LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default Find number of employee's working a Shift

OK heres a good one for you guys to help me with

A B C D E F
1Name In Out Total Pay Total
Employee Time Time Time Rate Pay

2 Sean 5:00 am 1:00 pm 8 $7.00 $56.00

Now On Sheet2 I want to pull the number of hours that sean worked between my
shift which are 5 to 11am, 11am to 1:30pm, 1:30 to 5:00pm 5 to 8pm and 8 to
12am. So if it works it would tell me that i had one employee for shift 5 to
11 and one for 11 to 1:30. Simple Right at least i hope so.
Thanks in advance
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CTRL+SHIFT+) is not working in Excel 2007 Nagender Rathi Excel Discussion (Misc queries) 5 December 24th 09 07:18 PM
held the shift key down for too long so now keyboard not working chmo Excel Discussion (Misc queries) 2 September 8th 09 10:00 PM
SHIFT + CONTROL + DOWN ARROW is not working! HERNAN Excel Discussion (Misc queries) 1 May 22nd 08 03:19 PM
Shift key to disable macros not working David P. Excel Discussion (Misc queries) 5 November 14th 05 07:52 PM
Return employee name when the employee's number is entered Mike Excel Worksheet Functions 1 September 16th 05 07:28 PM


All times are GMT +1. The time now is 11:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"