Thread: How to calcuate the difference between two times in tenths of a mi
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
  
Posts: 3,101
Default How to calcuate the difference between two times in tenths of a mi
I need to calculate the difference between two times and have the result
displayed in hours and tenths of the remaining minutes.

Example 1:
Time 1: Time 2: Result:
4:00 pm 8:30 pm 4.5

Example 2:
Time 1: Time 2: Result:
6:00 pm 10:45 pm 4.75


Reply With QuoteReply With Quote