| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using an IF statement on time based data
I have a worksheet of payroll time data by date that i want to identify
overtime amounts in excess of 8 hours. I can't seem to write an IF statement that correctly answers the question "If 8 hours or more, enter 8 hours, if less then the the calculated time. It seems to be a formatting problem of moving from time formats to number formats. HELP. Thanks -- DonB |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create a chart based on a 2 dim data range dynamical in 1 d | Charts and Charting in Excel | |||
| Create Charts based on data in Table | Charts and Charting in Excel | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Sharing data across worksheets within a workbook based on identifi | Excel Discussion (Misc queries) | |||
| populating sheets based on data from parent sheets | Excel Discussion (Misc queries) | |||
Threaded Mode
