Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am trying to build a spreadsheet so I can track my times at work. I am
having trouble trying to create a formula for 1 cell that will sum all the days of the month, and add a 1 for every 8 hours of standby time example: 01/02/05 4 hours of standby, 01/03/05 2 hours of standby, 01/04/05 8 hours of standby, 01/05/05 2 hours of standby, with the total being 16 I want that cell to calculate too 2. Thanks for any help you can provide!! Kevin. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Double-Clicking a cell for Multiple Options | Excel Discussion (Misc queries) | |||
How to make a cell recognize multiple text strings? | Excel Worksheet Functions | |||
Combining data (numeric format) in multiple cells into one cell (t | Excel Discussion (Misc queries) | |||
# of Functions per cell >> for Harlan Grove | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |