Thread: Time Question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spike9458 Spike9458 is offline
external usenet poster
 
Posts: 17
Default Time Question

10:00 am - 3:30 pm = 5:30 (5 hours and 30 minutes)

How do I convert the 5 hours and 30 minutes to 5.5 hours? I have tried
different formats but have not been able to get it right.

Thanks

--Jim