Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 45

Error in subtracting times

Good morning all,

Perhaps you can help with a question;

When subtracting times using the time format, and the answer is a negative
time, the answer shows like this ##########

Cell A1 20:00 - Cell A2 50:00 = Cell A3 #######

Is the any way to fix this?

Thank you in advance.

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
Subtracting Times	[email protected]	Excel Worksheet Functions	2	February 19th 07 04:47 PM
Subtracting times	gaftalik	Excel Discussion (Misc queries)	3	November 2nd 05 06:45 PM
Subtracting Times	NChris	Excel Worksheet Functions	1	February 10th 05 09:29 PM
Subtracting times	[email protected]	Excel Discussion (Misc queries)	1	January 12th 05 09:55 AM
Subtracting Times	tvhazlett	Excel Worksheet Functions	1	November 29th 04 05:05 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us