Time calculation kind of.....

  • Thread starter Thread starter dr_johns
  • Start date Start date
D

dr_johns

Seems like root of problem is that Excel can't tell there
is elapsed time between the 2 midnight entries. You sem
like a fairly experienced user, so without proposing an
exact fix, I'm thinking you could probably further
condition to your If test to force issue by testing for a
difference in dates (might have to use the MONTH function)
-----Original Message-----
Hello eevryone,
This is my first post ,and you all look so helpful....Here goes

B4=Start time (dd/mm/yy 13:30)
B5=Stop Time (dd/mm/yy 13:30)
B10=100
C1:L1= 1:24
C10 =B10 if C1 is between start and stop times.

RIght now Im using =IF(AND(C$1>HOUR($B$4),C$1<=HOUR
Click to expand...
($B$5)),$B$10,0). But if Start and Stop are both at
midnight (5/10/04 00:00 to 5/11/04 00:00), it doesnt work.
 
Back
Top