View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
WJPS WJPS is offline
external usenet poster
 
Posts: 2
Default Use custom [mm] formated value that is displayed in a calculat

Thankyou; that works.

"Gary''s Student" wrote:

If your date/times are in A1 and A2, then in A3 enter:

=(A2-A1)*24*60
--
Gary''s Student - gsnu200857


"WJPS" wrote:

How can the custom [mm] formated value that is displayed in a cell be used in
a calculation when it is the result of the difference between two dates
entered as d/mm/yy h:mm