View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ruthie ruthie is offline
external usenet poster
 
Posts: 12
Default Calculating Hours

I need to compute the difference between to times to the nearest quarter of
an hour.

For example, if someone enters 12:30 PM and 1:40 PM, I need to return the
number 5 (because there are 5 - 15 min increments). How do I do this?