Posted to microsoft.public.excel.misc

Liesel

Posts: n/a

formulas using date/time formats returning #value

Hi

Am dumping data out of an application - raw data appears as
5/26/2006 5:33:00 AM (i.e. mm/dd/yyyy hh:mm:ss AM/PM) - format all the
cells in custom format to this. However when I go to calculate the
difference between two times (elapsed time) returns #VALUE.
5/26/2006 5:33:00 AM less 5/26/2006 5:26:00 AM s/b 07:00

It's probably something very simple - can someone help please?

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
Countif formulas change after doing a sort	Bob Smith	Excel Worksheet Functions	3	January 3rd 06 11:17 PM
Problem with named formula's	nathan	Excel Worksheet Functions	0	January 21st 05 04:07 PM
Formulas	Stan	Excel Worksheet Functions	3	January 21st 05 02:58 PM
Cell Formats in formulas	C. Lewis	Excel Discussion (Misc queries)	1	January 5th 05 06:37 PM
extend data range formats and formulas	Lonnie	Setting up and Configuration of Excel	1	December 10th 04 11:33 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us