Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula/version 2007
help with time sheet formula
time in/time out/time in/time out/time in/time out can use as much as 3 ins and outs per day 8:30 am to 12:30 pm and 1:30 pm to 4:30 pm, this should equal 7 hours worked; what if a person enters 8:25 am to 12:30 pm and 1:30 pm to 4:30 pm, round to nearest quarter hour this still should be 7 hours; or 8:22 am to 12:30 pm and 1:30 pm to 4:30 pm, round to nearst quarter hour this should be 7.25, not (15min.) basicly it needs to round both ways to nearest quarter hour no matter what time they enter. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I save an Excel 97-2003 version or 2007 version for Mac 200 | Excel Discussion (Misc queries) | |||
Formula link in previous version not updated in Excel 2007 | Excel Worksheet Functions | |||
Chart from version 2003 to version 2007 | Charts and Charting in Excel | |||
How can I get the same colors from 2003 version to 2007 version? | Excel Discussion (Misc queries) | |||
links between 2007 version files and 97-2003 version files | Links and Linking in Excel |