Posted to microsoft.public.excel.programming

Bob[_75_]

external usenet poster

Posts: 7

Subtracting times

Hi, and thanks
For the life of me I can't figure this out, and I know it's simple.
in cell a1 have the time 09:22:45am
in cell a2 have the time 09:23:55am
I want to subtract and in cell a3 have the answer of 1:10
Do I have to format the cells as something else and not time?

Thanks Much
Bobby

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	[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
Subtracting times.	derek	Excel Programming	3	August 25th 03 12:06 AM

All times are GMT +1. The time now is 03:45 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us