Tracking an amount that accrues Daily

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Savage666 - 17 May 2008 00:20 GMT

I'm trying to get the vacation time for my store, which accrues at a rate of
.22 hr per day, to calculate and auttomatically adjust each day. How do i
write out the formula using the =Day() function* or the =NOW() function*? Or
is there a better way to express this?
Excel 2003

Reply to this Message

FSt1 - 17 May 2008 00:50 GMT

hi
first you have to have a base date - a date that the accruels started (and
doesn't change). at my company that is fiscal year start 4/1/XX.
with base date in A1....
=(today()-A1)*.22
might be better to use today() instead of now() because Now() calculates to
the second and today() calculates to the day.

regards
FSt1

> I'm trying to get the vacation time for my store, which accrues at a rate of
> .22 hr per day, to calculate and auttomatically adjust each day. How do i
> write out the formula using the =Day() function* or the =NOW() function*? Or
> is there a better way to express this?
> Excel 2003

Reply to this Message

JE McGimpsey - 17 May 2008 00:50 GMT

One way:

A1: <base date>
A2: =0.22/24 * (TODAY() - A1)

Reply to this Message

JE McGimpsey - 17 May 2008 00:55 GMT

Note: I assumed you'd want hours in Time format, hence the '/24' in the
formula.

If you want integral hours, delete that division.

> One way:
>
[quoted text clipped - 8 lines]
> > is there a better way to express this?
> > Excel 2003

Reply to this Message