Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello group,
I am new to Excel so please excuse my ignorance. I have a workbook that I am trying to make mathematical functions in a cell(if i said that correct)Anyway. This is what I have, and this is what I want to do. Vacation time earned 20.5 Days Vacation Time Taken 2.5 Days Vacation Time Remaining. 17.5 Days (Employees can only take half or hole days, not hours) I want the time taken field to keep a running total of time taken for 1 callander year and subtract it from Vacation Time Earned and display it in the Vacation time remaining cell. When I do this I use the simple =E8-E7 this is in the Time remaining field. this does give me the correct total for a one time entry, but not it I take more time off on a different date. E7 = Vacation Time Earned E8 = Vacation Time Taken E9 = Vacation Time Remaining When I enter more time off in to cell E8 it removes the previous time entered and subtracts it from E7 and the total is not correct. I hope this this doesn't sound stupid, but I kinda don't knowwhat I am doing. So any help would be great. Thanks, God Bless |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
interest rate mathematical formula | Excel Discussion (Misc queries) | |||
mathematical formula of rate | Excel Discussion (Misc queries) | |||
IS there a mathematical formula for NORMSINV? | Excel Worksheet Functions | |||
Mathematical elimination | Excel Worksheet Functions | |||
Please help with an excel mathematical formula | Excel Discussion (Misc queries) |