Posted to microsoft.public.excel.misc

Mark McDonough

Posts: n/a

Time function for timesheeets

What formula can I use to achieve the following result

Start 8.30am
Lunch half an hour
Finish 5.30 pm

Total time = 8.3 is the result required but can't get it to work.

Time involved is 8hours and 30mins.

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
numerical integration	integreat	Excel Discussion (Misc queries)	4	May 12th 06 02:40 AM
time sheet drop down lists	Steve	Excel Discussion (Misc queries)	12	March 18th 06 10:30 PM
=NOW() Time Function. I want this to be live!	Gareth Evans	Excel Worksheet Functions	7	August 11th 05 10:11 AM
Excel option to store trendline's coefficients in cells for use	Miguel Saldana	Charts and Charting in Excel	9	June 20th 05 08:45 PM
clock	Wildman	Excel Worksheet Functions	2	April 26th 05 10:31 AM

All times are GMT +1. The time now is 03:50 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us