Posted to microsoft.public.excel.misc

vdmbqb

external usenet poster

Posts: 36

subtract times with a negative result

I am using Office 2007.

I need a formula subtracting one time from another that can produce a
negative amount. The cells are formatted custom h:mm.

For instance Cell A1=6:30 Cell B1=6:45

If you subtract 6:45 from 6:30 I need a result of -0:15 (negative)

All I get is #########

Any help would be greatly appreciated.

--
bob

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
subtract a positive from a negative	wolfman	Excel Worksheet Functions	7	May 7th 13 11:30 PM
How to subtract[difference] in TIMES??	Crackles McFarly	Excel Worksheet Functions	9	August 21st 07 11:36 PM
Subtract times and let result go negative	Mr Wit	Excel Worksheet Functions	1	February 7th 06 09:03 PM
how do i subtract a negative number	anndee	Excel Worksheet Functions	2	June 11th 05 08:14 PM
excel should allow to add and subtract times	LV	Excel Worksheet Functions	10	December 10th 04 11:45 PM

All times are GMT +1. The time now is 05:03 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us