View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Meebers Meebers is offline
external usenet poster
 
Posts: 80
Default mad cows disease?

Alan, whilst in the middle of beer #2....the answer I get is "-10" cell
formatted as "general", else I get #######
"Alan" wrote in message
...
With the 11:00 in A1 and the 01:00 in B1
=(B1-A1)*24
Regards,
Alan.
"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.