![]() |
#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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |
![]() |
iuliandonici | Excel | 4 | 04-13-2011 09:27 PM |
![]() |
jetdude68 | Word Tables | 1 | 07-20-2010 12:30 AM |