Posted to microsoft.public.excel.worksheet.functions

Jsb

Posts: n/a

Formatting imported data

I am importing Data from my call center as follows:
10:35a Th Mar-23 JEF 02:37p Th Mar-23 JEF
this data comes into column A and B and I want to calculate the elapse time
in column C. I set up a custom format for each column "h:mm" and a formula in
C as =b1-a1 but I am getting an error #value!. Help.

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
UPDATING IMPORTED DATA	Jillian	Excel Worksheet Functions	13	January 12th 06 05:29 PM
Conditional formatting in a data table	TimR	Excel Discussion (Misc queries)	0	October 5th 05 07:28 PM
Excel changing number formatting and source data in graphs on it's own!!!	JohnHamer	Excel Discussion (Misc queries)	2	September 22nd 05 02:29 PM
my formatting changes do nothing to the data	Alex	Excel Worksheet Functions	5	July 17th 05 04:09 AM
imported data not recognised in formulae	arran1180	Excel Discussion (Misc queries)	2	February 16th 05 12:23 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us