| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
IF Question
If a normal working day is 8:00 AM - 5:00 PM and anything either over or
under that is counted as overtime, can I have one cell that tells me =IF(Actual Start<Normal Start,Normal Start-Actual Start,"") and add =IF(Actual EndNormal End,Actual End-Normal End,"") so that you can see how much over your 'Normal Hours' you have worked that day? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Newbie With A Question | Excel Worksheet Functions | |||
| Anybody Help with previous question | Excel Discussion (Misc queries) | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
| Question about combining data from multiple workbooks into one rep | Excel Discussion (Misc queries) | |||
| An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions | |||
Threaded Mode
