| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
subtracting hours and minutes
Hi all,
I have a value in A1 of 300:42 which represents 300 hrs and 42 mins. B1 contains 50.10 which also represents 50 hrs and 10 mins even though the separator is a decimal point and not a colon. What is the best way subtract B1 from A1 to return a value of 250:32? Thanks in advance Dave |
|
#2
|
|||
|
|||
|
One way
=A1-(INT(A2)/24+MOD(A2,1)/14.4) format result as [hh]:mm:ss -- Regards, Peo Sjoblom (No private emails please) "Dave" wrote in message ... Hi all, I have a value in A1 of 300:42 which represents 300 hrs and 42 mins. B1 contains 50.10 which also represents 50 hrs and 10 mins even though the separator is a decimal point and not a colon. What is the best way subtract B1 from A1 to return a value of 250:32? Thanks in advance Dave |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding hours and minutes | Excel Worksheet Functions | |||
| How do I add/subtract hours and minutes when some values exceed 2. | Excel Discussion (Misc queries) | |||
| How can I convert fractional hours to minutes? | Excel Discussion (Misc queries) | |||
| convert hours and minutes to minutes | Excel Discussion (Misc queries) | |||
| add column of minutes, show total in hours & minutes | Excel Worksheet Functions | |||
Linear Mode
