| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Calculations
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time Calculations
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time Calculations
Actually, thats' not time as in a clock, those are just numbers, format the
cell : custom ### "hours" "Dgwood90" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time calculations | New Users to Excel | |||
| Time difference calculations, daylight savings time, Excel | Excel Discussion (Misc queries) | |||
| Overlapping time calculations and automatic time updates | Excel Worksheet Functions | |||
| Time Calculations | Excel Worksheet Functions | |||
| convert time imported as text to time format for calculations | Excel Worksheet Functions | |||
Linear Mode
