Running Total, total usage for the day

[millerco]

Hello, I need help with a formula or macro(?) to provide the difference between to meter readings. The catch is I would like a running total reading ,similar to the odometer in your car, but the meter only has 7 digits, when the meter gets to 99999999, it rolls over to zeros but i need excel to do the math for the difference the two readings. Example: day one reading is 9898989, day two reading 0000005. usage would be 101011, but the only way i can figure to do it I get a neg number.


Thank you for your help.

Trevor

 

[jtakw]

Hi,

Since your meter readings may look like 0000123, which means they're formatted as Text, the following will work:

Book1
	A	B	C	D
1	1st reading	2nd reading		Total
2	9898989	0000005		101016
3	9876543	9934567		58024
Sheet34

Cell Formulas
Range	Formula
D2	=IF(B2+0)

 

[millerco]

That is awesome, thank you so much. Saved my ***.

Trevor

 

[jtakw]

You're welcome, welcome to the forum.

 

[millerco]

Another question, how can I stop this formula from calculating until cell B has the reading in it?

Thank you,
Trevor

 

[jtakw]

Use this updated formula:

Book1
	A	B	C	D
1	1st reading	2nd reading		Total
2	9898989	5		101016
3	9876543
4
5	9876543	9934567		58024
Sheet23

Cell Formulas
Range	Formula
D2	=IF(OR(A2="",B2=""),"",IF(B2+0))

Change the "" highlighted Red below to 0 if you prefer to show 0 rather than Blank.

=IF(OR(A2="",B2=""),"",IF(B2+0<A2+0,10000000-A2+B2,B2-A2))