| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Microsoft Excel Formula "IF" to create a timesheet
I used the following formula to create a timehseet. I work from 8:30 to 4:30
with an hour paid lunch from 11:30 to 12:30. This formula only gives me 7 hours. How can I change the formula to give me 8 hours? =IF((((D13-C13)+(F13-E13))*24)8,8,((D13-C13)+(F13-E13))*24) -- reagolly |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| How to create a scatter chart with 2 "X" values with common "Y"s | Charts and Charting in Excel | |||
| cannot use "Create List" and "Share Workbook" same time | Excel Discussion (Misc queries) | |||
| create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions | |||
| how to create the formula "cumsum" in excel | Excel Worksheet Functions | |||
Threaded Mode
