Thread: Difference Between Two Times
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Difference Between Two Times
Try this

=E20-C20+(E20<C20)

Apply a custom format of [mm]


Mike

"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