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


what excatly do u put in E7 ? is it 140:00:00 or 20.5 or...
1 day is how many time/min ?



"PuJo" skrev:

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



Simple,
Employe's are only able to use a half of a day, or a full day.
So in E7 it is listed as 1 for one day, or 2.50 for two and a half days.
No hours minutes or seconds are usen in this, just half or hole numbers.
Thanks for the respopnse
PuJo
God Bless.


"excelent" wrote:

what excatly do u put in E7 ? is it 140:00:00 or 20.5 or...
1 day is how many time/min ?



"PuJo" skrev:

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