Thread: CONVERT HOURS AND MINUTES TO INT
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
3Nails 3Nails is offline
external usenet poster
  
Posts: 9
Default CONVERT HOURS AND MINUTES TO INT
Calculated hours and mintues from time;

16:00 (4PM) to 19:30 (7:30PM) is 3:30.

How can I convert the results 3 hours and 30 minutes to 3.5 hours?
Reply With QuoteReply With Quote