Thread: Difference Between Two Times
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Difference Between Two Times
=MOD(E20-C20,1)*24*60 and format as General or Number
--
David Biddulph

ANYX wrote:
I am calculating the difference between times. C20 reflects the
start time 11:55 PM and E20 reflects the end time 12:15 AM. How do I
show the time difference in minutes?


Reply With QuoteReply With Quote