Posted to microsoft.public.excel.worksheet.functions

mikerobe

external usenet poster

Posts: 27

Number to time

Hi
An information system I work with outputs times as follows to a csv
file.

748 for 7:48
1236 for 12:36
1436 for 14:36
etc

It leaves out the colon. How can I change the values to represent
times instead of numbers. I am thinking along the lines of a function
using RIGHT function but cannot get it to work any help is appreciated.

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
number to time	Stan Halls	Excel Worksheet Functions	6	May 4th 07 01:56 AM
time into a number	Polochilde	Excel Discussion (Misc queries)	6	March 5th 07 04:12 AM
Every time i put a number with period it becomes a date and time	excelSOS	Excel Discussion (Misc queries)	7	March 7th 06 12:20 AM
Time as number	Howard	Excel Discussion (Misc queries)	4	June 23rd 05 09:12 PM
Time to number	Steved	Excel Worksheet Functions	3	April 27th 05 08:00 AM

All times are GMT +1. The time now is 10:02 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us