Thread: Time Difference
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Dave is offline
external usenet poster
 
Posts: 15
Default Time Difference

Tried everything on this, I have two times in a spreadsheet.One is 05:15 and
the other is 08:17. I need the exact difference between the two in hours to
three decimal places at least, so here it should show 3.033, instead all it
ever shows is 3.00. I've tried the hours function and Int function without
success.