Posted to microsoft.public.excel.worksheet.functions

Steve M

external usenet poster

Posts: 17

Problem with Time Addition

I have times imported into excel from my handheld. The times are put into
the handheld as 13:30 for 1:30PM. After inputing 13:30m 1:30PM automatically
shows up in the appropriate cell. After synchronizing to a spreadsheet on my
desktop I can't subtract one time from another. I get the result #VALUE!. I
have tried changing the formatting of the appropriate cell, butthis does not
help.

TIA

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
Another time addition problem	Martin B	Excel Worksheet Functions	2	April 14th 06 08:26 PM
time addition to predict finish time	Martin B	Excel Worksheet Functions	5	April 12th 06 11:44 PM
Time problem - Help please	sawagashi	Excel Discussion (Misc queries)	7	November 18th 05 10:15 PM
Time Problem	B. Baumgartner	Excel Discussion (Misc queries)	2	June 30th 05 09:05 PM
Addition problem, number always 2 cents off...Help	WTG	Excel Discussion (Misc queries)	3	March 30th 05 01:57 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us