View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fletch74 Fletch74 is offline
external usenet poster
 
Posts: 2
Default How do I subtract time?

I read that you can do (B1-A1)*24 but for the values where A is in PM and B
is in AM this returns a negative hour much larger than what it should be.
Any recommendations? Thanks.