Thread: Minus time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
  
Posts: 2,646
Default Minus time
=A1-1/24

Regards,
Stefi

€˛Tufail€¯ ezt Ć*rta:

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