View Single Post
  #2 (permalink)  
Old 11-19-09, 15:02
Ax238 Ax238 is offline
Registered User
 
Join Date: May 2009
Posts: 257
Just enter a formula in the Longest Time of B2-A2 and then format it the way you want. For example, you could format it as follows to get it to say "18 days, 05 hours, 47 minutes":
Code:
dd "days," hh "hours," mm "minutes"
You could also just format the cell as a number and get a value of 18.24.

Ax
Reply With Quote