View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Crackles McFarly Crackles McFarly is offline
external usenet poster
 
Posts: 49
Default How to subtract[difference] in TIMES??

WOW, too easy hu?

thanks a bunch

On Tue, 21 Aug 2007 13:36:19 -0700, "Peo Sjoblom"
sayd the following:

If you want integer minutes multiply by 1440 (value*24*60) and format as
general, if you just want to change the format use a custom format of [mm]
to format 00:15:00 to 15
To get decimal hours multiply with 24 and format as general or number