![]() |
|
#2
|
||||
|
||||
|
Supposing all time digits are in the hh:mm format ( 5 characters) the following seems to work
=SUMPRODUCT(-(RIGHT(A1:B1,5)))-SUMPRODUCT(-(LEFT(A1:B1,5))) adapt ranges as needed and format the result cell as needed also ( if you have more than 24 hrs remember to use [h]:mm)
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Add Numbers from One or Another Cell
|
Kilch | Excel | 3 | 01-31-2017 12:55 PM |
| Search a cell that contains words and numbers and convert the numbers to metric | Carchee | Excel Programming | 36 | 10-08-2014 03:16 PM |
| How to fill a cell with random numbers to do calculations? | zanat0s | Excel | 1 | 06-13-2011 10:33 AM |
Sum & difference between multiple values in a single cell
|
iuliandonici | Excel | 4 | 04-13-2011 09:27 PM |
adding numbers in same cell
|
jetdude68 | Word Tables | 1 | 07-20-2010 12:30 AM |