View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GL GL is offline
external usenet poster
 
Posts: 4
Default Time difference between two times

Hi,
How can I calculate with a formula the time difference between two times
when the second time is on the next day ( the cells are formatted as time ).
i.e. the difference between 17:00 today to 01:30 next day.
Thank you
GL