Jack Bible

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Time entry	leah	Excel Discussion (Misc queries)	9	January 18th 05 01:47 PM
entering numbers to display a time format	Ian Williams/Eazygig	Excel Discussion (Misc queries)	1	January 10th 05 11:57 AM
Help - Information with time and date	PM	Excel Discussion (Misc queries)	4	January 6th 05 08:25 AM
remove all Hyperlinks at one time.	afglass	Excel Discussion (Misc queries)	2	January 2nd 05 05:47 PM
Time Format Auto Entry AM and PM	BulaMan	Excel Discussion (Misc queries)	1	December 15th 04 09:30 AM

All times are GMT +1. The time now is 12:03 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us