No I11 is fixed at 15 to round time at 15 min. intervals.
Thank You all for your help.

Jack

RagDyeR wrote:

So ... that possibility *doesn't* exist for I11?<g
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"Jack Bible" wrote in message
...
Peo

This works very well.
Thanks
Jack

Peo Sjoblom wrote:

Why would anyone put a space in a time value?

=TIME(HOUR(TRIM(B11)),MROUND(MINUTE(TRIM(B11)),I11 ),0)

--
Regards,

Peo Sjoblom

(No private emails please)

"Jack Bible" wrote in message
...
I am using "=TIME(HOUR(B11),MROUND(MINUTE(B11),I11),0)" for
a time card, but if a space is entered we get #VALUE error. How can
these spaces be filtered out. Input "06:00" or "06:00 am" works, but "
06:00" gives #VALUE error.

Thanks
Jack