decimal time subtraction please.

[Steved]

Hello from Steved

Below is Decimal

Each minute = 60

7.45 minus 8.35 to leave 50 please

Formula for the above

Thankyou.

 

[crispbd]

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)))

 

[Steved]

Thankyou

 

[Steved]

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.

 

[crispbd]

9.00 - 7.00 returned 120 for me. Try formatting the decimal time colum
as text (making sure that 2 decimal places are shown

 

[Steved]

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.

 

[Steved]

Hello from Steved

I've found a solution

DOLLARFR(DOLLARDE(M306,60)-DOLLARDE(C306,60),60)

Cheers.