Formula Calculate after a certain time of day.
 

Did you mean 16.5, rather than 16.3?

As a matter of interest, why the TIMEVALUE(TEXT(A1,"hh:mm")) rather than
MOD(A2,1)? I had heard that there could be small errors with MOD, but I
thought that this needed very large numbers to cause the error?
--
David Biddulph

"muddan madhu" wrote in message
...
try this

=IF(TIMEVALUE(TEXT(A1,"hh:mm"))16.3/24,TRUE,FALSE)




On Oct 17, 11:07 pm, Kathy - Lovullo
wrote:
I have a spreadsheet in which one of the columns has a field which
contains
the date & time. I want to put a formula in another column to return a
value
of "True" if the time is after 4:30 PM, regardless of the date.

I am having trouble figuring out the correct formula and any help would be
greatly appreciated.

Formula Calculate after a certain time of day.
 

As far as I know the bug in MOD is that it will return the #NUM! error with
very large numbers and small divisors

I believe things like millionth of a decimal is basically nothing but the
regular floating point errors

--


Regards,


Peo Sjoblom

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Did you mean 16.5, rather than 16.3?

As a matter of interest, why the TIMEVALUE(TEXT(A1,"hh:mm")) rather than
MOD(A2,1)? I had heard that there could be small errors with MOD, but I
thought that this needed very large numbers to cause the error?
--
David Biddulph

"muddan madhu" wrote in message
...
try this

=IF(TIMEVALUE(TEXT(A1,"hh:mm"))16.3/24,TRUE,FALSE)




On Oct 17, 11:07 pm, Kathy - Lovullo
wrote:
I have a spreadsheet in which one of the columns has a field which
contains
the date & time. I want to put a formula in another column to return a
value
of "True" if the time is after 4:30 PM, regardless of the date.

I am having trouble figuring out the correct formula and any help would
be
greatly appreciated.