Thread: Minus time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
  
Posts: 3,101
Default Minus time
enter in B1
=A1 - TIME(1,0,0)

"Tufail" wrote:

hi,
i have in cell A1 current time and in cell B1 i want show minus 1hr from
current time so plz someone help me, thanks in advance.

A1 (C-Time) B1
16:00 15:00
Reply With QuoteReply With Quote