Sorry, copied the wrong cell.
Try this:
=TIME(HOUR(TRIM(B11)),MROUND(MINUTE(TRIM(B11)),TRI M(I11)),0)
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"RagDyeR" wrote in message
...
Try this:
=TIME(HOUR(TRIM(B11)),,)
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"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
|