Home |
Search |
Today's Posts |
#1
|
|||
|
|||
decimal time subtraction please.
Hello from Steved
Below is Decimal Each minute = 60 7.45 minus 8.35 to leave 50 please Formula for the above Thankyou. |
#2
|
|||
|
|||
In Cell A1: 8.35 In Cell B1: 7.45 =(VALUE(LEFT(A1,LEN(A1)-3)) * 60 + VALUE(RIGHT(A1,2))) - (VALUE(LEFT(B1,LEN(B1)-3)) * 60 + VALUE(RIGHT(B1,2))) -- crispbd ------------------------------------------------------------------------ crispbd's Profile: http://www.excelforum.com/member.php...o&userid=10880 View this thread: http://www.excelforum.com/showthread...hreadid=320247 |
#3
|
|||
|
|||
Thankyou
-----Original Message----- In Cell A1: 8.35 In Cell B1: 7.45 =(VALUE(LEFT(A1,LEN(A1)-3)) * 60 + VALUE(RIGHT(A1,2))) - (VALUE(LEFT(B1,LEN(B1)-3)) * 60 + VALUE(RIGHT(B1,2))) -- crispbd ---------------------------------------------------------- -------------- crispbd's Profile: http://www.excelforum.com/member.php? action=getinfo&userid=10880 View this thread: http://www.excelforum.com/showthread...hreadid=320247 . |
#4
|
|||
|
|||
Hello crispbd from Steved
Is it possible please to make your formula more robust ie 9.00 - 7.00 If I put in 9.05 - 7.05 returns 120 but type in 9.00 - 7.00 it returns #value! Thankyou. -----Original Message----- In Cell A1: 8.35 In Cell B1: 7.45 =(VALUE(LEFT(A1,LEN(A1)-3)) * 60 + VALUE(RIGHT(A1,2))) - (VALUE(LEFT(B1,LEN(B1)-3)) * 60 + VALUE(RIGHT(B1,2))) -- crispbd ---------------------------------------------------------- -------------- crispbd's Profile: http://www.excelforum.com/member.php? action=getinfo&userid=10880 View this thread: http://www.excelforum.com/showthread...hreadid=320247 . |
#5
|
|||
|
|||
9.00 - 7.00 returned 120 for me. Try formatting the decimal time column as text (making sure that 2 decimal places are shown) -- crispbd ------------------------------------------------------------------------ crispbd's Profile: http://www.excelforum.com/member.php...o&userid=10880 View this thread: http://www.excelforum.com/showthread...hreadid=320247 |
#6
|
|||
|
|||
Hello Crispbd from Steved
Thanks but by doing by your formula if I type 8 and hit enter it will put 8 but having it formatted as a number then I type 8 the result will be 8.00, as I've several off these I would prefer a formula that would work with 8.00 not 8 as a text number. Thanks. -----Original Message----- 9.00 - 7.00 returned 120 for me. Try formatting the decimal time column as text (making sure that 2 decimal places are shown) -- crispbd ---------------------------------------------------------- -------------- crispbd's Profile: http://www.excelforum.com/member.php? action=getinfo&userid=10880 View this thread: http://www.excelforum.com/showthread...hreadid=320247 . |
#7
|
|||
|
|||
Hello from Steved
I've found a solution DOLLARFR(DOLLARDE(M306,60)-DOLLARDE(C306,60),60) Cheers. -----Original Message----- 9.00 - 7.00 returned 120 for me. Try formatting the decimal time column as text (making sure that 2 decimal places are shown) -- crispbd ---------------------------------------------------------- -------------- crispbd's Profile: http://www.excelforum.com/member.php? action=getinfo&userid=10880 View this thread: http://www.excelforum.com/showthread...hreadid=320247 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
entering numbers to display a time format | Excel Discussion (Misc queries) | |||
Help - Information with time and date | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions |