Posted to microsoft.public.excel.worksheet.functions

connie

external usenet poster

Posts: 46

how do i calculate the number of hours between 11:00 am & 4:00 pm

I need a formula or function that will calculate the number of hours between
11:00 am and 4:00 pm = 5 hours.

Thanks, Connie Smith

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
Calculate hours worked	larry_saudi	New Users to Excel	5	October 11th 06 07:46 PM
Is it possible to convert a number into hours and minutes	le clef	Excel Worksheet Functions	4	April 1st 06 05:43 PM
calculate number of days btw dates	Nelson	Excel Worksheet Functions	2	March 2nd 06 01:02 AM
Creat a formula to calculate working hrs according to number of da	Bren	Excel Worksheet Functions	2	August 1st 05 12:57 PM
calculate average hours and minutes	llstephens	Excel Worksheet Functions	4	November 30th 04 03:47 PM

All times are GMT +1. The time now is 07:56 AM.

About Us

"It's about Microsoft Excel"