Posted to microsoft.public.excel.worksheet.functions

Cold1

external usenet poster

Posts: 1

If statements

I am putting together a time card for my work. I have figured out how to
figure the times, but if "holiday" is put into the time slot I need "8" to go
into the hours cell automaticly. Here is my current time sheet.

=IF((OR(D11="",C11="")),0,IF((D11<C11),((D11-C11)*24)+24,(D11-C11)*24))

I need to place 8 in cell J21.

Any help would be greatly appreciated.

Thank you,

Craig Old

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
IF Statements	Joe	Excel Worksheet Functions	2	June 30th 08 05:48 PM
IF Statements (Mutliple Statements)	Deezel	Excel Worksheet Functions	3	October 19th 06 06:13 AM
How My If Or Statements	John	Excel Worksheet Functions	1	April 24th 06 07:50 PM
if and and statements	Combining multiple if & and statements	Charts and Charting in Excel	2	April 20th 06 01:29 PM
If Statements	tropezfn	Excel Worksheet Functions	6	April 11th 06 04:58 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us