I have a total in A1 and B2

I want B2 to be subtracted from A1 every second of the day.. Based on the
Current Time in D4
D4 contains =now()

Is this what you want:
=a1-b2*mod(d4,1)*86400
Format as number

Regards,
Fred

"Jman" wrote in message
...
I have a total in A1 and B2

I want B2 to be subtracted from A1 every second of the day.. Based on the
Current Time in D4
D4 contains =now()

"Fred Smith" wrote:

Is this what you want:
=a1-b2*mod(d4,1)*86400
Format as number

Regards,
Fred

"Jman" wrote in message
...
I have a total in A1 and B2

I want B2 to be subtracted from A1 every second of the day.. Based on the
Current Time in D4
D4 contains =now()


.
for example

In A1 i have 1,254,435 (food) total
In B2 i have 34,436 (food) that is being consumed every hour

This means that every hour a total of 34,436 food is being deducted from A1

I just wanted to know how much time do i have left until the food runs out
in A1

based on the current time in D4.. which contains the "=now()" formula.

In your first message, you wanted to subtract B2 for "every second of the
day". In this message it's every hour. In the first message, you wanted to
know what was left in A1, now you want to know how many hours you have left.
You'll get better responses when you define your problem better.

Here's some suggestions.
=a1/b2 is the number of hours of food that you have.

You need to define the starting time. Using =now() seems of no value to me.
Why start from midnight? Why isn't it when people start eating the food?

Regards,
Fred

"Jman" wrote in message
...


"Fred Smith" wrote:

Is this what you want:
=a1-b2*mod(d4,1)*86400
Format as number

Regards,
Fred

"Jman" wrote in message
...
I have a total in A1 and B2

I want B2 to be subtracted from A1 every second of the day.. Based on
the
Current Time in D4
D4 contains =now()


.
for example

In A1 i have 1,254,435 (food) total
In B2 i have 34,436 (food) that is being consumed every hour

This means that every hour a total of 34,436 food is being deducted from
A1

I just wanted to know how much time do i have left until the food runs out
in A1

based on the current time in D4.. which contains the "=now()" formula.

"Fred Smith" wrote:

In your first message, you wanted to subtract B2 for "every second of the
day". In this message it's every hour. In the first message, you wanted to
know what was left in A1, now you want to know how many hours you have left.
You'll get better responses when you define your problem better.

Here's some suggestions.
=a1/b2 is the number of hours of food that you have.

You need to define the starting time. Using =now() seems of no value to me.
Why start from midnight? Why isn't it when people start eating the food?

Regards,
Fred

"Jman" wrote in message
...


"Fred Smith" wrote:

Is this what you want:
=a1-b2*mod(d4,1)*86400
Format as number

Regards,
Fred

"Jman" wrote in message
...
I have a total in A1 and B2

I want B2 to be subtracted from A1 every second of the day.. Based on
the
Current Time in D4
D4 contains =now()


.
for example

In A1 i have 1,254,435 (food) total
In B2 i have 34,436 (food) that is being consumed every hour

This means that every hour a total of 34,436 food is being deducted from
A1

I just wanted to know how much time do i have left until the food runs out
in A1

based on the current time in D4.. which contains the "=now()" formula.

.
My bad i wasnt clear enough, it was late when i responded and i mixed up my response with a whole new question. i had in mind.
This is mostly what i was lookin for.
thanks..

Here's some suggestions.
=a1/b2 is the number of hours of food that you have.