LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 24
Default Assigning times to shift

Working with spreadshift containing date and times of events during a one
month period. I converted the cell content from date and time to time (23:00
format).

Now I want to go back and associate events with a given shift, i.e., If
B2=(7,0,0) AND time <=(15,0,0), "Days" (or it could just be a value, ie.,
1)

If I want to assign the value to one of three shifts, can I just string all
three formulas together and separate with commas?

Keep getting formula error.
Arghhh.

Thanks in advance for any help.
Help?????
 
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
Program for assigning work shift hours frankiee Excel Discussion (Misc queries) 1 March 10th 06 02:54 AM
IS THERE A FORMULA TO MAKE E=6:00PM ETC SHIFT TIMES AND HOURS Angel Devoid Excel Worksheet Functions 2 December 28th 05 06:25 PM
How are relay leg times or driving times entered and totaled? commissioner Excel Worksheet Functions 1 July 26th 05 09:27 PM
Subtracting lunch breaks from different shift times badger Excel Discussion (Misc queries) 5 June 27th 05 04:10 PM
How do I turn off Mouse Scroll in Excel(Shift key 5-times)? PC_Joe Excel Worksheet Functions 1 May 19th 05 07:48 PM


All times are GMT +1. The time now is 01:58 PM.

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"