Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Katybug1964
 
Posts: n/a
Default Need a function that separates over-lapping work shift hours.

We have temporary employees; sometimes an employee's hours will run over into
the next shift. Based on noting the employee's hours, I need a function
that will automatically sort out which hours are First Shift, which are
Second Shift, and so forth. Furthermore, I want the function to provide the
actual number of hours worked on that shift in a separate cell.

I'm thinking this will probably be a nested function, I haven't been able to
locate a function that will allow me to do the intial calculation. Any
suggestions?

Thank you.
Reply
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
Automatically up date time in a cell Mark Excel Discussion (Misc queries) 5 May 12th 05 12:26 AM
hOW DO I GET THE XCELL FUNCTION CUMPRINC TO WORK? Asterix Excel Worksheet Functions 1 March 25th 05 02:03 AM
Nested if, sum & vlookup Function Trying to excel in life but need help Excel Worksheet Functions 4 January 13th 05 08:29 PM
GCD Function doesn't work in some cases GCD_Dilemma Excel Worksheet Functions 5 November 8th 04 09:18 PM
Counting Function Dilemma Simon Lloyd Excel Worksheet Functions 0 November 8th 04 04:13 PM


All times are GMT +1. The time now is 03:24 PM.

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

About Us

"It's about Microsoft Excel"