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.

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

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

.

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

.

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

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

.

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

.