| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timesheet - Formula
Great - thanks for your help.
"David Biddulph" wrote: 5 hours is 5/24, or TIME(5,,) -- David Biddulph --Viewpoint wrote: Goal: I want to subtract lunch time if I work over 5 hours, otherwise I want to know the hours worked if under 5 hours) Details: Cell A10 - lunch time, cell is number format, time Cell E10 - time I arrived at work, custom cell format h:mm AM/PM Cell F10 - time I leave work, custom cell format h:mm AM/PM Cell B10 - is cell to enter the formula and then convert it to decimal =If(F10-E10 is greater than 5 hours, then F1-E10-A10, else, F10-E10)*24 (it is mandatory to take lunch if you work 5 hours or more) Can anyone provide the correct formula and/or cell formats? My problem is that I don't know how to recognize the 5 hours in the formula. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Timesheet formula problem | Excel Worksheet Functions | |||
| timesheet and overtime formula/s | Excel Discussion (Misc queries) | |||
| Need help with a timesheet formula | Excel Discussion (Misc queries) | |||
| Timesheet Formula Help Please! | Excel Worksheet Functions | |||
| TIMESHEET FORMULA | Excel Worksheet Functions | |||
Hybrid Mode
