Posted to microsoft.public.excel.misc

vdmbqb

external usenet poster

Posts: 36

time formulas

I have times generated in h:mm in cell A1 and A2 I need a formula in A3 that
subtracts A2 from A1 and produces the difference (either negative or
positive) in h:mm.
For instance, the time in A1 is 6:15 and the time in A2 is 6:00 I need A3
to return -:15 or -0:15. All I can get is ###########.

Thank you in advance for any help offered.

--
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
Time formulas	Blazingsaddles	Excel Worksheet Functions	15	October 9th 07 10:51 PM
Time Formulas	MuncieJeff	Excel Discussion (Misc queries)	2	December 8th 06 10:22 PM
Using Time in Formulas	Cheri	Excel Discussion (Misc queries)	6	November 10th 06 04:58 PM
Time Formulas	metaltecks	Excel Discussion (Misc queries)	1	March 30th 06 12:51 AM
Time formulas	famdamly	Excel Discussion (Misc queries)	1	March 1st 06 04:34 PM

All times are GMT +1. The time now is 08:25 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us