Time Calculations
From: Brettmw23 (anonymous_at_discussions.microsoft.com)
Date: 04/18/04
- Next message: Leo Heuser: "Re: Finding Kth largest value in a column with duplicates"
- Previous message: Bonj: "Re: Add-in functions when starting Excel programmatically"
- In reply to: Matt: "Time Calculations"
- Next in thread: Bob Phillips: "Re: Time Calculations"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 18 Apr 2004 08:45:06 -0700
Matt, perhaps I'm misunderstanding what your attempting to do, but it
seems to me you're only testing one side of the problem. For instance, your
only checking if it's greater than your start time. When you really need to
find out if it's between your start and end time.
It seems to me that you could use something like:
=If(And(A1<C1,B1>C1),True,False).
-- BMW >-----Original Message----- >Hello to all, >A1 "Start time" 3/13/04 07:00 >B1 "Stop Time" 3/13/04 23:00 >C1 3/13/04 16:00 > >I am tryin to determine if the one hour time period preceeding C1 eg. 3/ 13/04 15:00-16:00, falls between A1 and B1. Curently I am using A1< C1 -1/24, which is working. Is there a better way to accomplish this, are there any forseen problems with my approach? > >Thanks > >. >
- Next message: Leo Heuser: "Re: Finding Kth largest value in a column with duplicates"
- Previous message: Bonj: "Re: Add-in functions when starting Excel programmatically"
- In reply to: Matt: "Time Calculations"
- Next in thread: Bob Phillips: "Re: Time Calculations"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
