Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi, Diane-
You may find it useful to reconsider how employees accumulate time off, and how they spend it. Companies I've worked for express vacation in terms of hours- if you get 10 vacation days per year, that's 10 days times 8 hours per day = 80 vacation hours. If you express everything in a single time unit you will avoid converting back and forth, as well as testy little arguments about what constitutes a "day", for instance. (You could also easily divide by 8 to convert hours to work days.) Is that a possibility? Dave O |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUMProduct working most of the time... | Excel Discussion (Misc queries) | |||
Working with dates and time | Excel Discussion (Misc queries) | |||
formula help working with time | Excel Discussion (Misc queries) | |||
working with time functions | Excel Discussion (Misc queries) | |||
Working time and days | Excel Discussion (Misc queries) |