Current Time subtract a specific amount every second

  • Thread starter Thread starter Jman
  • Start date Start date
J

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 said:
Is this what you want:
=a1-b2*mod(d4,1)*86400
Format as number

Regards,
Fred



.
for example
Click to expand...

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
 
Fred Smith said:
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.
Click to expand...
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.
 
Back
Top