View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steved Steved is offline
external usenet poster
 
Posts: 519
Default 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.