Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statements query
Hi I am trying to create a time sheet.
Where column A is the date (ddd, dd,mmm,yyyy) in column B I would like it to enter the time 9:15 (hh:mm) if the day is Monday, Tuesday, Wednesday or Thursday and then enter 0:00 if it is Friday, Saturday or Sunday. Is this at all possible? If so how would I go about working this out? Any help appreciated. Many thanks JayM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Calculated field using IF statements in the Query Grid | New Users to Excel | |||
Conditional statements in MS-Query? | Excel Discussion (Misc queries) | |||
Excel MS Query multiple select statements | Excel Discussion (Misc queries) | |||
Use SQL statements in Excel VBA to query SQL Server Data Problem | Excel Worksheet Functions |