Thread: Convert Time to Number
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Convert Time to Number
With 9:00 in A1 and 11:30 in A2, in A3 enter:
=24*(A2-A1) and format as General.
--
Gary''s Student - gsnu200816
Reply With QuoteReply With Quote