Posted to microsoft.public.excel.worksheet.functions

MyVeryOwnSelf[_3_] MyVeryOwnSelf[_3_] is offline

external usenet poster

Posts: 56

If statement to work out time/overtime

... A1 & B1 that holds start time and end time of work done.

C1 should work out the time between 08:00 and 17:00

D1 should work out overtime, (hours worked before 08:00 and after 17:00)

If a shift cannot span midnight, the following might work:

C1:
=MIN(B1,TIME(17,,))-MAX(A1,TIME(8,0,))

D1:
=B1-A1-C1

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
Work hours with overtime	Debby_Jo	Excel Discussion (Misc queries)	2	July 31st 08 12:29 AM
Calculating Regular time, overtime and double time	Brian Smith	Excel Worksheet Functions	5	November 9th 07 10:32 PM
Detailed Time Sheet (overtime, comp time, vacation used)	Robert D. Sandersfeld	New Users to Excel	2	May 22nd 06 10:14 PM
Work out overtime hours for individuals	Fudge	New Users to Excel	3	April 26th 06 12:52 PM
Work out overtime hours for individuals	Fudge	New Users to Excel	13	April 10th 06 04:10 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us