Just use

=A2-A1

--
__________________________________
HTH

Bob

"Dgwood90" wrote in message
...
I need a formula that will subtract battery run time and show time left.
For example
battery run time = 40 hours
Time running = 25 hours
Time Left = 15 hours
Everything I have tried relates to a 24 hour time.