Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi -
I have a caregiver who comes 3 times a week. There is a time limit of 38 hours per month for how long she's allowed to be here. I have a timesheet set up to keep track of her hours. The usual time she's here each day is 3 hours. I've been trying to keep track of the over/under amount to know how much time she has left for the month - would like help, please. As a secondary matter, I would like to format the over 3 hours amounts, when they occur, in red. tia |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculate the amount of time over a permitted amount (12 hours) | Excel Discussion (Misc queries) | |||
Adding amount from 1 colum depending on # piece amount in colum 2 | Excel Discussion (Misc queries) | |||
adding an amount to each cell | Excel Worksheet Functions | |||
Adding to an amount in a cell | Excel Discussion (Misc queries) | |||
How can I calculate amount of time left based on amount spent? | Excel Worksheet Functions |