Posted to microsoft.public.excel.worksheet.functions

Kjaltrik

external usenet poster

Posts: 5

TimeSheet! Working PM to AM

I'm making a timesheet and it's working good.
But I can't work out how to calculate mu working time from ex: 15:00 to
18:30 lunchbreak and then 19:20 to 02:00. The calculated anser I get is
"-13.83"

I hope somebody can help me

Thanx

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
Highlighted Reference Cell for a Working Cell	Mr. Low	Excel Worksheet Functions	0	June 22nd 06 04:27 PM
Working spreadsheet highlighting function for Excel 2007	Mr. Low	Excel Worksheet Functions	4	June 16th 06 06:12 PM
Calling another workbook not working	malik641	Excel Worksheet Functions	2	June 24th 05 07:36 PM
overtime on timesheet	kimmyrt	Excel Worksheet Functions	4	January 26th 05 07:33 PM
timesheet with running total of overtime	kimmyrt	Excel Worksheet Functions	2	January 26th 05 06:15 PM

All times are GMT +1. The time now is 06:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us