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