View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default mad cows disease?

Hi

Try
=MOD(B1-A1,1)
where B1 = finish, A1 = start

--
Regards
Roger Govier



"Meebers" wrote in message
...
Brain fade....trying to find time elapse from 11:00pm to 01:00 am the next
day to get 2:00. Can't recall the function to do this in addition to the
simple subraction. So far...one cold beer did not help.