Decimal Time Subtractions
 

Hello from Steved

Wanting total minutes only please.

=DOLLARFR(DOLLARDE(S87,60)-DOLLARDE(K87,60),60)

I have Analysis ToolPak as an Add In

Here's my issue
In Cell K87 I have 11.50 and in Cell S87 I have 1.00 it returns "-10.5"
It should return "70"

Yes I should have done as in 11:50am and 1:00pm and formated it as [H]:M

Thankyou.

Decimal Time Subtractions
 

Try this:
=TIME(INT(S87)+12,MOD(S87,1)*100,0)-TIME(INT(K87),MOD(K87,1)*100,0)
and format the result cell as [m]

Regards,
Stefi


€žSteved€� ezt Ã*rta:

Hello from Steved

Wanting total minutes only please.

=DOLLARFR(DOLLARDE(S87,60)-DOLLARDE(K87,60),60)

I have Analysis ToolPak as an Add In

Here's my issue
In Cell K87 I have 11.50 and in Cell S87 I have 1.00 it returns "-10.5"
It should return "70"

Yes I should have done as in 11:50am and 1:00pm and formated it as [H]:M

Thankyou.

Decimal Time Subtractions
 

Thankyou

"Stefi" wrote:

Try this:
=TIME(INT(S87)+12,MOD(S87,1)*100,0)-TIME(INT(K87),MOD(K87,1)*100,0)
and format the result cell as [m]

Regards,
Stefi


€žSteved€� ezt Ã*rta:

Hello from Steved

Wanting total minutes only please.

=DOLLARFR(DOLLARDE(S87,60)-DOLLARDE(K87,60),60)

I have Analysis ToolPak as an Add In

Here's my issue
In Cell K87 I have 11.50 and in Cell S87 I have 1.00 it returns "-10.5"
It should return "70"

Yes I should have done as in 11:50am and 1:00pm and formated it as [H]:M

Thankyou.

Decimal Time Subtractions
 

You are welcome! Thanks for the feedback!
Stefi

€žSteved€� ezt Ã*rta:

Thankyou

"Stefi" wrote:

Try this:
=TIME(INT(S87)+12,MOD(S87,1)*100,0)-TIME(INT(K87),MOD(K87,1)*100,0)
and format the result cell as [m]

Regards,
Stefi


€žSteved€� ezt Ã*rta:

Hello from Steved

Wanting total minutes only please.

=DOLLARFR(DOLLARDE(S87,60)-DOLLARDE(K87,60),60)

I have Analysis ToolPak as an Add In

Here's my issue
In Cell K87 I have 11.50 and in Cell S87 I have 1.00 it returns "-10.5"
It should return "70"

Yes I should have done as in 11:50am and 1:00pm and formated it as [H]:M

Thankyou.