Time Function

  • Thread starter Thread starter DannyJ
  • Start date Start date
D

DannyJ

=IF(II22<TIME(7,30,),I22-TIME(7,30,),"")

Hi there,

in I22 the time is 07:38. I would expect the above function to return a
blank cell. Instead it returns 00:08. Why?

many thanks,

Danny
 
I tried various stuff, 7.38, 7:38 as text, and couldn't get anything other
than blank.
 
DannyJ said:
=IF(II22<TIME(7,30,),I22-TIME(7,30,),"")

Hi there,

in I22 the time is 07:38. I would expect the above function to return a
blank cell. Instead it returns 00:08. Why?
Click to expand...

i think it might be just typo. i mean I22 instead of II22.

keizi kounoike
 
DannyJ said:
=IF(II22<TIME(7,30,),I22-TIME(7,30,),"")
in I22 the time is 07:38. I would expect the above function to return a
blank cell. Instead it returns 00:08. Why?
Click to expand...

Think its a typo in your formula, should be I22 instead of II22
in: ... II22<TIME(7,30,) ... ??

II22 probably is just a far away, unused empty cell, that's why <g>
 
Back
Top