| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How many hours in the last 7 days did I work?
I need help putting together a formula for these rolling time periods please.
I have hour limits on time worked. I can: -Work no more than 16 hours straight. And, -Work no more than 16 in any 24 hours. And -No more than 28 in any 48 hours. And -No more than 72 hours in 7 days. And -At least 8 hours between shifts. Very limiting but I've been unable to figure a formula/formulas using time of the day you worked - or scheduled to be worked. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting total number of hours (24 hours) into days | Excel Discussion (Misc queries) | |||
| Subtract time between certain days/work hours? | Excel Worksheet Functions | |||
| Convert days in decimal to days:hours:minutes | Excel Worksheet Functions | |||
| Convert decimal days to Days,hours, minutes | Excel Worksheet Functions | |||
| Problem converting Hours to Days, Hours, Minutes | Excel Worksheet Functions | |||
Threaded Mode
