View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BookWight BookWight is offline
external usenet poster
 
Posts: 2
Default adding up time over & under a specified amount

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