Posted to microsoft.public.excel.programming

Ozbobeee[_3_] Ozbobeee[_3_] is offline

external usenet poster

Posts: 7

Convert data entry to mins:secs

Hi,

Would someone be kind enough to assist with code to automatically
convert:

data entry 1234 to 12:34 (12 mins:34 secs)

Thanks in advance

Bob

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
How to sum hours, mins, secs (00:00:00)?	Dave	Excel Discussion (Misc queries)	8	June 4th 09 01:36 PM
Format Cells for Mins / Secs	Chris Cornell	Excel Worksheet Functions	2	June 3rd 07 05:56 AM
how can i convert a value quoted in hrs,mins,secs to just mins	The man from delmonte	Excel Worksheet Functions	1	October 17th 06 11:12 AM
Importing Mins:Secs	Terry Pinnell	Excel Discussion (Misc queries)	3	October 11th 06 06:54 PM
Convert mins:secs to seconds only	ronedwards	Excel Worksheet Functions	3	November 3rd 05 11:10 PM

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

About Us

"It's about Microsoft Excel"