View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Use custom [mm] formated value that is displayed in a calculation

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