Posted to microsoft.public.excel.misc

KC1952

external usenet poster

Posts: 1

Time calculation of 8:00 am - 4:30 pm at 8.5 hours How???

I am trying to calculate the time between 8:00 am and 4:30 pm. It is giving
me 8 hours only and not the 8.5 hrs. Is there a way I can do this?

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
Schedule hours calculation	RJ Swain	Excel Discussion (Misc queries)	6	November 21st 06 09:32 PM
HOURS CALCULATION	Stuart Carnachan	Excel Discussion (Misc queries)	2	October 31st 06 04:26 PM
Time (Hours) calculation	Corey	Excel Worksheet Functions	1	June 16th 06 07:28 AM
How do add time/hours to get answer in hours if Ans24	Fran	Excel Worksheet Functions	2	May 20th 06 05:50 AM
Convert hours and minutes in time format into fractions of hours..	Akern	Excel Worksheet Functions	4	April 21st 05 02:56 PM

All times are GMT +1. The time now is 10:52 AM.

About Us

"It's about Microsoft Excel"