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: 3
Default I need Time Range to return Value

I need to get a Value Based on Start time.

If the Start time is between 7:00 and 14:59 = First
If the Start time is between 15:00 and 21:59 = Second
If the Start time is between 22:00 and 6:59 = Third
Values will show in Column "D"
A B C D
1 Name Start End Shift
2 John Doe 8:00 17:00 Value?

Any 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
Return date if in range, else return blank LisaL Excel Worksheet Functions 1 July 22nd 09 03:23 PM
drop first row in range and return a new range object Rik Excel Programming 1 November 19th 08 10:12 AM
I need to return the lowest time value in a range of cells. al elkins Excel Worksheet Functions 2 January 26th 07 06:24 AM
Return Range Address from Active Range ExcelMonkey Excel Programming 1 February 10th 06 12:00 PM
use the current time to return a value [email protected] Excel Discussion (Misc queries) 2 November 28th 05 05:08 PM


All times are GMT +1. The time now is 06:43 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"