Thread: Compute duration and miles-per-hour and total miles
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GARYWC GARYWC is offline
external usenet poster
  
Posts: 80
Default Compute duration and miles-per-hour and total miles
When I format B as Time 00:00:00, the displayed result is 2:55:00

How can I get the display to be 2 HRS 55 MINS?

Reply With QuoteReply With Quote