Decimal Time Subtractions

  • Thread starter Thread starter Steved
  • Start date Start date
S

Steved

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.
 
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:
 
Thankyou

Stefi said:
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.
Click to expand...
Click to expand...
 
You are welcome! Thanks for the feedback!
Stefi

„Steved†ezt írta:
Thankyou

Stefi said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top