View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pattio Pattio is offline
external usenet poster
 
Posts: 7
Default formula for converting military time to standard time, etc

I have 5 cells in a row (A1 - A5). I need to subtract, in military time, A1
from A2 and then A3 from A4 and the total should be in A5 as standard time.
Cells A1-A4 are formatted as hhmm and cell A5 is formatted as hh:mm.