Current Time subtract a specific amount every second

[Jman]

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]

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

Regards,
Fred

 

[Jman]

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

Regards,
Fred



.
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]

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]

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



.
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.