LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate the amount of time over a permitted amount (12 hours) Steve M Excel Discussion (Misc queries) 9 June 2nd 10 09:25 PM
Adding amount from 1 colum depending on # piece amount in colum 2 hotrodflatglass Excel Discussion (Misc queries) 2 March 17th 10 06:22 PM
adding an amount to each cell mark Excel Worksheet Functions 3 August 4th 08 10:47 PM
Adding to an amount in a cell Roberta Excel Discussion (Misc queries) 5 August 12th 07 02:48 AM
How can I calculate amount of time left based on amount spent? KLD Excel Worksheet Functions 3 May 23rd 06 04:20 PM


All times are GMT +1. The time now is 07:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"