One way:

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

In article ,
Savage666 wrote:

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