Posted to microsoft.public.excel.worksheet.functions

Debbie[_4_] Debbie[_4_] is offline

external usenet poster

Posts: 24

Time Value Between Two Times

Here is another scenario.

If F85 is greater than or equal to 8:30 am but less than or equal to
9:00 am, then I need it to return a 1, If it is not between 8:30 am
and 9:00 am then I need it to return "B". I have the cell formated as
time 00:00 AM. What am I doing wrong?

IF(AND(F85=8:30,F85<=9:00),1,"B")

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Difference between times. Start time: 11:30PM End time: 5 AM	Surrey	Excel Worksheet Functions	5	March 3rd 09 06:31 PM
Add times, convert to number not time of day?	spezticle	New Users to Excel	4	September 18th 08 08:07 PM
IS A TIME BETWEEN TWO TIMES EG 12:00 & 8:00	Shirley4589	Excel Worksheet Functions	20	August 11th 08 10:20 AM
Time difference between two times	GL	Excel Worksheet Functions	1	March 7th 07 04:43 PM
Compare times : IF time < time2 then	[email protected]	Excel Worksheet Functions	4	July 12th 06 11:36 AM

All times are GMT +1. The time now is 05:30 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us