Time Tracking

[jamesmev]

I am stumped on this and don't know where to start.

I am looking to create a form where it tracks time used (simple...)

However, in 366 days that time will be added back to the pool. .

I was able to do this with one date but a running list caused issue.

Pool starts at 48.
Each time you select time from a "bucket" it reduces the amount available to use.

My thoughts are

A1 - Pool
B1 - Time Used

A7 - Date
B7 - Time Used
C7 - Date time become available again (366 days)


Example:::
Date - 1/1/2018
Time Used - 4hours
Date Avail - 1/2/2019

 

[jamesmev]

Solved:
F1 = Today
D1= Time Used
G1 = Time Used + 366
E1 = Hours used

=IF (F1<G1,(E1*0),(E9)) --- This gives a zero if the date is earlier than today... and a sum if beyond today. Total the sum and subtract from available hours.

 

[jtakw]

Hi,

Can't see the formula you're using, try putting a space before and after < and/or > signs.
If you're using the TODAY() function in a cell and/or formula, and adding 366 days to it for Available again, it will never happen, because the TODAY() formula will update the date everyday.

 

[jamesmev]

Hi,

Can't see the formula you're using, try putting a space before and after < and/or > signs.
If you're using the TODAY() function in a cell and/or formula, and adding 366 days to it for Available again, it will never happen, because the TODAY() formula will update the date everyday.

Today () is okay. The "Today" needs to be before the current day and will always change. if they use 5 hours on 2/1/17

and the date today is 1/1/18 + 366 days from that date is below "Today"
However if the date is 2/5/18. 366 days from that date is above "Today" which clears out the need.

=IF(F9 < G9,(E9*0),(E9)) <g9,(e9*0),(e9))"< html=""></g9,(e9*0),(e9))"<>

 

[jtakw]

Ok, didn't quite understand your description at first, and without seeing your formula, thought you were adding 366 to TODAY(), glad you got it to work the way you need.