Posted to microsoft.public.excel.misc

GARYWC

external usenet poster

Posts: 80

Difference between two times

F16 contains 18:30:00 and is displayed as 6:30 PM
H16 contains 20:42:00 and is displayed as 8:42 PM

(Both cells a Format Cells: Number; Custom; Type: h:mm AM/PM)

What formula do I put in D16 so the difference between H16 and F16 is displayed as 2 hr 12 mins ?

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
Difference Between Two Times	ANYX	Excel Discussion (Misc queries)	5	March 14th 09 12:24 AM
Difference between 2 times	Mike H.	Excel Programming	2	December 21st 07 07:01 AM
Difference between two times	Jester	Excel Discussion (Misc queries)	4	August 31st 06 01:36 PM
Difference in Times	bcbjork	Excel Discussion (Misc queries)	6	August 27th 05 03:42 PM
difference between 2 times	xlsxlsxls	Excel Programming	3	August 18th 04 01:07 PM

All times are GMT +1. The time now is 05:36 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us