Duke Carey

Posts: n/a

Use
=mod(date_time value,1)
& format it as time

If it is a text value, use
=TIMEVALUE(RIGHT(text value,8))
& format it as time

"gb_S49" wrote:

Hmmmm is it possible for a formula to just extract the time aspect?
30/03/2005 14:17:00

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
Jerry Lewis LUCK ?	OZDOC1050	Excel Worksheet Functions	1	December 29th 04 01:13 PM
LUCK ?	OZDOC1050	Excel Worksheet Functions	3	December 29th 04 01:13 PM
Toggle betwen "editing" and "pushing" a button in excel	brjohnson9	Excel Discussion (Misc queries)	1	December 9th 04 12:02 AM

All times are GMT +1. The time now is 05:15 AM.

About Us

"It's about Microsoft Excel"

Search
Home
Contact Us
Today's Posts
Register Now
FAQ

Menu

About Us