Thread: Subracting Time.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GEM GEM is offline
external usenet poster
  
Posts: 90
Default Subracting Time.
How do I subtract time?? For example

A1=20:00 HRS
B1=15:00 HRS
C1=(A1-B1)-1

I want to always subtract 1:00 hour from the result. , =(A1-B1)-1 I get,
######
How can I get 4:00 as the answer??
Reply With QuoteReply With Quote