Posted to microsoft.public.excel.worksheet.functions

Jafferi[_2_] Jafferi[_2_] is offline

external usenet poster

Posts: 22

Count the number of hours/durations

Cell A1 ---- Jan 1, 2010
Cell A2 ---- 10:58 [AM]
Cell B1 ---- Jan 3, 2010
Cell B2 ---- 22:10 [PM]

What is the formula that I can use to give me the results of no of hours
between Jan 1, 2010 at 10:58AM to Jan 3, 2010 22:10 PM?

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
Count hours dr	Dave08	New Users to Excel	2	October 15th 08 12:24 PM
Converting total number of hours (24 hours) into days	MV Rao	Excel Discussion (Misc queries)	1	January 24th 08 12:50 PM
Count hours per month	Derek	Excel Worksheet Functions	3	September 19th 07 11:52 AM
durations	chad	Excel Discussion (Misc queries)	5	May 30th 07 02:33 PM
wages - multiply hours and minutes by number of hours worked	Carol (Australia)	Excel Discussion (Misc queries)	6	April 1st 07 01:16 AM

All times are GMT +1. The time now is 07:14 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us