Posted to microsoft.public.excel.misc

John Boulton John Boulton is offline

external usenet poster

Posts: 1

Formatting time for m:ss.00

I would like to be able to format columns/cells to read time inthe format
m:ss.00 or alternatively m:ss:00 (for determining beaten margins of
racehorses the finishing times are given in the above formats but excel
doesn't appear to want to mix or match them
any assistance would be appreciated
JB

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 formatting	MD	Excel Worksheet Functions	3	June 28th 07 11:49 PM
Time formatting	Eileen	New Users to Excel	2	October 3rd 05 09:34 PM
Time formatting	danlinksman	Excel Worksheet Functions	2	December 7th 04 12:21 AM
time formatting and time categorizing (vlookup or data validation)	MarianneR	Excel Worksheet Functions	4	November 18th 04 03:24 PM
time formatting and time categorizing (vlookup or data validation)	MarianneR	Excel Worksheet Functions	0	November 18th 04 03:13 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us