Thread: Calculating Minutes and Time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Franz Franz is offline
external usenet poster
  
Posts: 6
Default Calculating Minutes and Time
ONTENT cell A2 CONTENT cell B2 B2 - A2 B2 - A2
03/15/05 09:30 AM 03/16/05 08:25 AM 22:55 1375
FORMAT FORMAT FORMAT FORMAT
mm/dd/yy hh:mm AM/PM mm/dd/yy hh:mm AM/PM hh:mm General
FORMULA FORMULA
=B2-A2 =(B2-A2)*60*24

Reply With QuoteReply With Quote