View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jmj713 jmj713 is offline
external usenet poster
 
Posts: 57
Default Difference in Time

I did a search on this topic and the solutions given for some reason don't
work for me.

I need a simple formula that will give me a difference between two times
(for instance, between 2:00 and 1:30 being 0:30).

One formula I found was =(A1-B1)*24 but it did not work. Any suggestions?